Hi,
I have several sheets with column (B) that has data in from B3 onwards. I have a macro on a seperate worksheet that needs to scan each column B and do calculations on the data.
In the past i have defined the range and then used the this to scan that range. However the rang in this case could be anything from 1 row to 1000's. How do I define that:
Please Login or Register to view this content.
Bookmarks