I use HlcLastCell=oWorkbook.ActiveCell.SpecialCells(xlLastCell).Address() to return the last occupied cell address. However, the result is returned as "$AC$31258" even after setting ReferenceStyle to 2. How can I return the cell reference by Number (ie R1C1 Format) ?

Please help

Fred Matano