Parameter Passing

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sjnn
    New Member
    • Oct 2015
    • 1
    #1

    Parameter Passing

    Hi All,

    I'm new to excel need help.

    My requirement is My data is available in one sheet and I want to pass the each cell value to VBA macro.

    I've approx 60 lines/rows (Single column only) of data. And this is Dynamic ( I mean we manually copy from email and paste in excel).

    Regards,
    Tags: None
    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32636
      #2
      VBA Macros are processors of data and not receptacles thereof. With that in mind I have to say your question doesn't really make sense.

      We can help you to access the data in a worksheet from your VBA code, and there are many ways to achieve this, but to store it there as your question implies just doesn't make sense.

      Perhaps you could clarify your question for us. Please don't rush a response off. Maybe your first attempt suffered from this. Take your time and explain your situation more clearly. Remember to include all relevant information that we may need in order to answer you in a way that's truly helpful.

      For now, the methods Range() and Cells() of the ActiveWorksheet object are the most common ways to refer to the data within the currently active worksheet.

        Comment

        Previous template Next
        Working...