How to find the last row or last column in any excel sheet
LR = ActiveSheet.UsedRange.SpecialCells(xlLastCell).Row
LC = ActiveSheet.UsedRange.SpecialCells(xlLastCell).Column
or
LR= range("A65536").end(xlup).row
Lc=range("IV1").end(xltoleft).column
