The following macro pulls calculated data from another worksheet and then performs a calculation based on that copied over data, then moves down a row and repeats. It is currently set-up to go down 300 rows. I want it to stop after it hits an empty cell in column C, but have not been able to figure it out. Any help is appreciated.
Please Login or Register to view this content.
Try something like
to work out what the last row is (in this case based upon column 1)Please Login or Register to view this content.
Martin
Thank you for the amazingly quick response! How do I incorporate that into the macro? I tried replacing "endRow= 300" with your recommendation, and it just keeps going. I tried it with changing (Rows.Count,1) to (Rows.Count,3) thinking it would key on column C, but it just kept going. I tried a couple of Different "Loop Untils" but no luck. I'm still very green with macros, but I'll get there...
Check that.... I can make the macro work. Currently I have this as the third macro to be run in a set. The first one copies over the base data, removes duplicates and sorts. The second one just sets up the formula on the other worksheet, and then this one. If I run this one by itself, it works and stops at the right place. When I try and run the set, it just keeps going. What causes that?
Difficult to tell without seeing the workbook itself. You might try putting a breakpoint on the new line of code and hover over the endRow variable with your mouse - do you get the correct line number. If not, the right sheet might not be active at the point that you have the line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks