Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I find last populated cell in a row (or column)
Damn interface:
Row: Dim lastCell As Range Set lastCell = Range("IV" & Columns.Count).End (xlToLeft) Column: Dim lastCell As Range Set lastCell = Range("A" & Rows.Count).End(xlUp) -----Original Message----- Hi, how can I find last populated (not null) cell in a row (or column) thanx alekm . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I find last populated cell in a row (or column)
Me being a dumba**:
Row: Dim lastCell As Range Set lastCell = Range("IV" & 1).End(xlToLeft) -----Original Message----- Damn interface: Row: Dim lastCell As Range Set lastCell = Range("IV" & Columns.Count).End (xlToLeft) Column: Dim lastCell As Range Set lastCell = Range("A" & Rows.Count).End(xlUp) -----Original 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 | |||
Find the first or last populated column in a range | Excel Worksheet Functions | |||
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 |