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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - command to return the row number or cell number in excel? (https://www.excelbanter.com/excel-programming/285115-command-return-row-number-cell-number-excel.html)

desmondleow[_5_]

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

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

--
Message posted from http://www.ExcelForum.com

Jan Karel Pieterse

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

All times are GMT +1. The time now is 08:36 PM.