command to return the row number or cell number in excel?

D

desmondleow

Can anyone tell me the code to return the row and column of the cel
where i am in for VBA
 
J

Jan Karel Pieterse

Hi Desmondleow,
Can anyone tell me the code to return the row and column of the cell
where i am in for VBA?

Msgbox "Row number is:" & Activecell.Row
Msgbox "Column number is:" & Activecell.Column

Regards,

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