cavemonkey
06-13-2007, 10:59 PM
hi
I'm wondering what's the difference between these 2 code?
lrow = ActiveSheet.Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row
and this
lrow = ActiveSheet.Range("A65536").End(xlUp).Row
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?
lrow = ActiveSheet.Range("A" & ActiveSheet.Columns.Count).End(xlUp).Column
Please advise.
I'm wondering what's the difference between these 2 code?
lrow = ActiveSheet.Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row
and this
lrow = ActiveSheet.Range("A65536").End(xlUp).Row
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?
lrow = ActiveSheet.Range("A" & ActiveSheet.Columns.Count).End(xlUp).Column
Please advise.