By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Parameter Passing

P: 1
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).

Oct 16 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
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.
Oct 16 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.