| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
