So I am trying to figure the best way to select all cells in column B in the workbook I'm opening beginning with cell B2 and down to the last filled cell in column B. The SetRng line of code I have commented out works great for the range B2 to B201. But what if I have cells beyond 201 or... what if only cells B2, B3 and B4 are filled? I had hoped that my second SetRng statement would be a bit more efficient but it produces an 'Object Required' error.
Please Login or Register to view this content.
Bookmarks