Guys,
Just a quick one, I amusing 2003 and have a sheet with data up to row 65536.
who cares you ask..
well when i use
[vba]lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row[/vba]
My lastRow value returns 1 not 65536, i could write a simple if statement, ie if 1 then 65536
but i would like to know, if there are any other ways of handling this.
Thanks
G