It gives the address of a cell. Just format its return as you wish:

?ObjExcel.ActiveSheet.Range("A1").SpecialCells(11).Address(.f.,.f.,-4150)
?ObjExcel.ActiveSheet.Range("A1").SpecialCells(11).Address()
?ObjExcel.ActiveSheet.Range("A1").SpecialCells(11).Address(.f.,.f.)
.....

See more on address property in VBA for Excel Help.



>That seem to work great. Thanks a lot
>
>Not sure how it works though
>.Range("A1").SpecialCells(xlLastCell).Address(.f.,.f.,xlR1C1)