I'm performing calculations on a data set in Column A and starting in cell 2 (cell A1 is a column header). Each time I run the calculation, I don't know how many data points I will be transferring to this column. What VBA code will automatically find the data range in column A starting with cell A2.
Thanks!
Last edited by ConfusedToo; 04-18-2009 at 06:04 PM. Reason: Solved
Does this help
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Re: Data Range in Column
Yes, thanks so much. It captures the data range. .
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Solved. :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks