go to last filled cell in a column shortcut
I have different size files that have data on every other row. I need to
locate the last row that has data in it. I would like to start at the top (B1) of column B and be able to use a shortcut or macro to immeadiately go to the last cell that has data in column B. any ideas? Thanks in advance -- inthestands |
go to last filled cell in a column shortcut
inthestands wrote:
I have different size files that have data on every other row. I need to locate the last row that has data in it. I would like to start at the top (B1) of column B and be able to use a shortcut or macro to immeadiately go to the last cell that has data in column B. any ideas? Ctrl + end seems to do the trick (at least in my Danish Excel). /Sune |
go to last filled cell in a column shortcut
Sub findbottom()
ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Select End Sub Gord Dibben MS Excel MVP On Mon, 30 Oct 2006 10:45:01 -0800, inthestands wrote: I have different size files that have data on every other row. I need to locate the last row that has data in it. I would like to start at the top (B1) of column B and be able to use a shortcut or macro to immeadiately go to the last cell that has data in column B. any ideas? Thanks in advance |
All times are GMT +1. The time now is 09:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com