728x90
Worksheets("Sheet1").Range("A65536").End(xlUp).Row
Worksheets("Sheet1").Cells(1, Columns.Count).End(xlToLeft).Column
Worksheets("Sheet1").Range("A65536").End(xlUp).Row
Worksheets("Sheet1").Cells(1, Columns.Count).End(xlToLeft).Column