Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hi Andibevan,
From my understanding you can't physically select a dynamically named range so it is hard to tell what it is selecting you _can_ see the range when editing the formula in (translated from german): Insert/Name/Define select your name and place the cursor in the formula "refers to" at the bottom, then you will see "ants" running around your range (wow, good english...) otherwise run a little makro to higlight "myrange" Sub Makro1() Application.Goto Reference:="myrange" End Sub arno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Indirect and dynamic ranges | Excel Worksheet Functions | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |