This may help:
*xlLastCell=11
*xlR1C1 = -4150
lcLastCell = ObjExcel.ActiveSheet.Range("A1").SpecialCells(xlLastCell).Address(.f.,.f.,xlR1C1)
?ObjExcel.ActiveSheet.UsedRange.Rows.Count
?ObjExcel.ActiveSheet.UsedRange.Columns.Count

>Hi everyone,
> I am working on a project where I open an existing excel sheet and add information to it from a DBF file. So far I figured out how to open the spreadsheet and add to it but I am having trouble finding out what column I can start at. I don't want to write over data that is already there. Does anyone know how to find the first available column? I think the concept is to go end of the spreadsheet "A65536" and then CRTL+END but having trouble getting it to work. Any help would be greatly appreciated.
>Thanks