I'm sure this is subjective, but what is the best (ie. fastest operating) way to locate the last cell in a spreadsheet? I have a macro that needs to scan all the used cells in a sheet by creating a named range that covers all the used cells.
Right now my code uses the Usedrange.Columns.Count, but I'm finding that it frequently ends up dozens of cells past where actual data is coded, sometimes all the way to col IV.
I've seen the solutions selecting a cell all the way at the end and doing a xlLeft, but these are usually per row. I need to know at what cell is the intersection of the last row and column.
Anybody have a better way?
Thanks!
Right now my code uses the Usedrange.Columns.Count, but I'm finding that it frequently ends up dozens of cells past where actual data is coded, sometimes all the way to col IV.
I've seen the solutions selecting a cell all the way at the end and doing a xlLeft, but these are usually per row. I need to know at what cell is the intersection of the last row and column.
Anybody have a better way?
Thanks!