Links to Dynamic Named Range = Problem
Thanks for trying. I've gone back to making it a named range and will just
have to remember to update it!!
"T. Valko" wrote:
Sorry, I'm out of ideas.
--
Biff
Microsoft Excel MVP
"Code Numpty" wrote in message
...
Thanks Biff
My range now refers to
=Prices!$A$1:INDEX(Prices!$A$1:$Z$10000,MATCH("*", Prices!$A$1:$A$10000,-1),MATCH("*",Prices!$A$1:$Z$1,-1))
and works perfectly.
However, I'm still getting the links cannot be updated message.
.
|