ExcelBanter - How can I get current cell row number

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I get current cell row number (https://www.excelbanter.com/excel-discussion-misc-queries/50884-how-can-i-get-current-cell-row-number.html)

excelneophyte

How can I get current cell row number

I need to reference the row value of the current cell

Rowan Drummond

How can I get current cell row number

in a worksheet function: = row()
in VBA: activecell.row

Hope this helps
Rowan

excelneophyte wrote:
I need to reference the row value of the current cell

All times are GMT +1. The time now is 09:10 AM.