| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I find last populated cell in a row (or column)
Hey Frank! The guy asked for the cell, not the row!
-----Original Message----- 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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I find last populated cell in a row (or column)
Hi
o.k. agreed. use msgbox cells(lastrow,"A") -- Regards Frank Kabel Frankfurt, Germany gigglefritz wrote: Hey Frank! The guy asked for the cell, not the row! -----Original Message----- 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 . |
| Reply |
| 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 | |||
Linear Mode
