This may help to navigate:

LastRow=ObjExcel.ActiveSheet.UsedRange.Rows.Count
LastColumn=ObjExcel.ActiveSheet.UsedRange.Columns.Count
lcLastCellAddress = ObjExcel.ActiveSheet.Range("A1").SpecialCells(11).Address(.f.,.f.,-4150)


>Hi All,
>How do you move to the bottom (the cell after the last cell with info) of a column programaticaly?
>Thanks,