So I am wondering if there is a way to overcome this as it seems to believe that the cells are populated, when in fact they are not?
It's finding the last row in columns F through to CC so whatever that row number is will be what's selected
If you only want to find the last row in column F as your original post stats, use this:
If you can't resolve the issue, attach a work book with one tab showing how the data currently looks and another tab showing how'd you like it to look and I'll take a look (can't promise anything).
Robert
Bookmarks