Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I find last populated cell in a row (or column)
Hi
for a column try something like sub foo() Dim Lastrow LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row msgbox lastrow end sub -- Regards Frank Kabel Frankfurt, Germany alekm wrote: Hi, how can I find last populated (not null) cell in a row (or column) thanx alekm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find last populated cell in range of cells | Excel Worksheet Functions | |||
Find the first or last populated column in a range | Excel Worksheet Functions | |||
Last populated cell in a column | Excel Discussion (Misc queries) | |||
Last populated cell in a column | Excel Discussion (Misc queries) | |||
Referencing last populated cell in a column | Excel Worksheet Functions |