Hi Lsb,

I would like to know how can I obtain the cell address in
integer format.


Dim lRow as Long
Dim iCol as Integer
lRow=Activecell.Row
iCol=Activecell.Column

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com