hi

I'm wondering what's the difference between these 2 code?

[VBA]
lrow = ActiveSheet.Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row
[/VBA]

and this

[VBA]
lrow = ActiveSheet.Range("A65536").End(xlUp).Row
[/VBA]

since these 2 are to count last row then what about counting column? for the first code, will it work if I just change the rows to columns?

[VBA]
lrow = ActiveSheet.Range("A" & ActiveSheet.Columns.Count).End(xlUp).Column
[/VBA]

Please advise.