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
|