Hi

Knows someone a way to get the number of active row (the row of currently selected cell) as a name?

I.e.
1. I will have a name p.e. ActiveR = SomeFormula;
2. When I select any cell on same worksheet, ActiveR equals with row number of selected cell;
3. When I enter the formula =ActiveR into any cell on this worksheet, the displayed row number reflects the cursor position only - not the cell position with formula in it.

I know I can write an UDF to get this, but is there a way to do this using regular formulas only (because the workbook with formula in it will be accessed by different people in different locations and with Excel2007 and later many of them will have problems with Trust Center)?


Thanks in advance!
Arvi Laanemets