Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Retrieve Last Used Cell In Column
I'm having trouble figuring out how to do this. Could someone help me
out. All of the cells before the last used cell may or may not be filled with something. In the end I'm going to need the row number of this cell as well. Any help is greatly appreciated! Thanks :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Retrieve Last Used Cell In Column
Hi Marshall
Sub LastCellInColumnA() Range("A" & Rows.Count).End(xlUp).Select End Sub this will give you the row Range("A" & Rows.Count).End(xlUp).row -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Marshall" wrote in message ... I'm having trouble figuring out how to do this. Could someone help me out. All of the cells before the last used cell may or may not be filled with something. In the end I'm going to need the row number of this cell as well. Any help is greatly appreciated! Thanks :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Retrieve Last Used Cell In Column
Marshall,
Dim lrow as Long lrow = Cells(Rows.COUNT, "A").End(xlUp).Row This finds the last used cell in column A, regardless of any blank cells. Change "A" to any column you want. -- sb "Marshall" wrote in message ... I'm having trouble figuring out how to do this. Could someone help me out. All of the cells before the last used cell may or may not be filled with something. In the end I'm going to need the row number of this cell as well. Any help is greatly appreciated! Thanks :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find duplicate cells in Column a & retrieve column B | Excel Discussion (Misc queries) | |||
How To Retrieve Data From Last Cell In Column? | Excel Discussion (Misc queries) | |||
retrieve last entry in column | Excel Worksheet Functions | |||
retrieve column index... | Excel Discussion (Misc queries) | |||
retrieve a column I hid for printing | Excel Worksheet Functions |