Go to last used cell in a row and/or column

[ammartino44]

Hello. How can I go to the last used cell in a row or column. I know about command up/down/left/right but I need to go the absolute last used cell and there are blank spaces in my data. Maybe vba code? I'd like to create a shortcut based on the row/column that I'm in.

[hoyasaxa215]

Try ctrl+end

[ammartino44]

That's what I just said haha. THere are blanks so that doesn't work.

[hoyasaxa215]

ctrl+end will go to the last row/column regardless of blanks.

[ammartino44]

Hmmm, that doesn't really work. Try it yourself. Write a bunch of numbers in a column. Control - End doesn't take you to the last cell in the column.

[ammartino44]

It takes you to the last cell period, which isn't what I need.

[Ouka]

ya know, in the various code snipets I've given you in the last couple of days, I've got finding the last populated cell in a column in there several times.

here it is, again:

Please Login or Register  to view this content.

Which is literally saying:

"Activesheet" - On the Activesheet
".Cells(rows.count, 1)" - count the number of rows in col 1 (A) to the end of the worksheet.
".end(xlup)" - from the bottom row work back UP to the last cell that isn't blank.
".row" - Return that row number.

there are other ways to do this, but I've always found this one the easiest.