I have data in 4 rows and 5 columns.
Sub test()
Dim lr, lc As Long
1) lr = Range("a" & Rows.Count).End(xlUp).Row - This works fine and i get lr = 4
2) lc = Range("a" & Columns.Count).End(xlToLeft).Column ( lc = 1, wonder why this is the case, shouldnt it be 5?)
3) lc = Cells(1...