View Single Post
  #2   Report Post  
arno
 
Posts: n/a
Default

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