I found a subroutine on the web which finds the last row and column cell address. I’ve attached a copy of the code in the attached worksheet. When I run this code I get an error. Can someone tell me how to fix the problem? Or, maybe suggest a simpler approach?
Note that what I’m trying to do is to be able to select a table of values (strings and numbers) without selecting the title or any other empty cells or cell formatting that might have been left behind. I usually get the spreadsheet from other users who have put in the data, so it’s important for me to select only the listed data range so I can do data munipulation such as filtering and sorting.
Thanks.
