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

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

Post by desmondleo » Fri, 12 Dec 2003 18:49:58


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

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

Post by Jan Karel » Fri, 12 Dec 2003 19:51:20

Hi Desmondleow,


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

Regards,

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