Find last cell in a sheet

[Eldrod]

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!

 

[Tom Urtis]

To Excel, a used cell could have formatting but no data, so it depends on how you define "last cell".

See if either of these links help you depending on last row, last column, used range, or unknown range:

http://www.atlaspm.com/faqvbalastcolumn.html#62

http://www.atlaspm.com/faqvbausedrange.html#63

http://www.atlaspm.com/faqvbaunknownrange.html#65

 

[Eldrod]

Thanks, Tom. That second link had just what I was looking for!

 

[datadrvn]

I don't know if this will bump this year-old post back up the list but the links to the solution for this question no longer work...and this is precisely something i need to do, i.e., find the last cell in a sheet that contains data.

I tried searching other posts without luck...can find the last row...but looking to find the last cell.

Can anyone help? Thx. Wayne

Excel 2007

 

[datadrvn]

I feel foolish. I think I ended my search a tad too early. The below fuction seems to do the trick...I just can't remember which thread I found it in now. I'm sorry to the author...the credit isn't mine.

ActiveCell.SpecialCells(xlLastCell).Select

Sorry to have bothered folks...regards...Wayne