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

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
.

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
.