| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row number within a named range
Hello,
I have a named range called "Versions" and it's located in "A10:A15". When I select Range "A12" I get 12, when I use ActiveCell.Row. What I'd like to know is the relative row in Range "Versions", which would be 3. What' s the syntax for it? Thanks. Regards Werner Excel XP SP3 Win XP SP1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using named range to extend print area for variable number of columns | Excel Worksheet Functions | |||
| Last Row Number in a Named Range | Excel Worksheet Functions | |||
| VBA: find number of columns in named range? | Excel Discussion (Misc queries) | |||
| Number of Rows & Columns in a Named Range | Excel Discussion (Misc queries) | |||
| How to count number of pages in a named range | Excel Programming | |||
Threaded Mode
