View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default command to return the row number or cell number in excel?

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