| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last filled cell in a column
Hi VJ,
Dim rgLastCell as range Set rgLastCell=Activesheet.range("A65536").End(xlup) Regards, Sébastien "VJ" wrote: Hi, Is there any way I can find out the last filled cell in a column? For exmaple I have col A and in that column first five cells filled up and then next three cells are empty and then again next five are filled up. I need to find the last cell in the column which is filled up. Help would be appreciated. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Filled Cell | Excel Discussion (Misc queries) | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| go to last filled cell in a column shortcut | Excel Worksheet Functions | |||
| How to find last filled in cell in a column? | Excel Worksheet Functions | |||
Threaded Mode
