Active cell row number... without using code

[TomH]

Is there a function that allows me to report into a cell the active cell row number without using VBA? I want the row number of the active cell to be reported when the active cell is within a specific range, but not otherwise. For example, if the active cell is in the range D10-D40, I want the row number to be reported in cell A1, but otherwise I want it to be blank.

Any help is greatly appreciated.

 

[techsupport1]

Hi Tom,

There is one way to do this but it does not calculated automatically, you have to press f9 to update it whenever you want the value to be displayed.

=IF(AND(CELL("row")<41,CELL("row")>9),CELL("row"),"")

This is assuming the range you provided is what you want (10-40).

It's possible to have this automatically displayed but VBA must be used.

Hope this helps

 

[TomH]

Hope this helps

Thanks. It does indeed.

It's possible to have this automatically displayed but VBA must be used.

How disappointing. i.e. ARRRGGGHHH!!! lol


Thanks again.