Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I find last populated cell in a row (or column)
Assuming you don't have any null rows in a cell or column and you know
the starting cell, you can use: Selection.End(xlToRight).Select 'For Columns Selection.End(xlDown).Select 'For Rows Cells(65536, "A").End(xlUp).Row 'Used if there are null rows and you need to find the absolute last cell Where Selection is your starting cell. HTH "alekm" wrote in message ... Hi, how can I find last populated (not null) cell in a row (or column) thanx alekm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I find last populated cell in a row (or column) | Excel Programming | |||
how can I find last populated cell in a row (or column) | Excel Programming | |||
how can I find last populated cell in a row (or column) | Excel Programming | |||
how can I find last populated cell in a row (or column) | Excel Programming | |||
how can I find last populated cell in a row (or column) | Excel Programming |