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

I can't really work out what you're aimning for here. Except for when you're entering a formula, the active cell address (column and row) is displayed on the Ribbon's Home tab, just above the top-left corner of the visible range.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Active cell is the one where your cursor points at, not one the formula resides in.

Anyway, I decided there is no way to solve this with regular worksheet functions only, so I did find an alternative solution - so the case is closed.

The task was to design a worksheet for keeping a grouped registry of item ID's, where ID's are growing from 1 to 999 for every grop on every calendary day - and I needed to know next available ID for currently entered item irrespective of table ordering.

Arvi Laanemets

No, holding the cursor over a cell does not make it active. You need to click on it first. A selection can span multiple cells, but only one cell can be active - the one missing the highlight.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]