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

  • Thread starter Thread starter desmondleow
  • Start date Start date
D

desmondleow

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

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

Regards,

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