Yes the named arange is an absolute range. Is this what could be causing the
problems?

"Bob Phillips" wrote:

Is the name referring to an absolute range?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Confused_Euffy" wrote in message
...
I have named some ranges and wish to apply them to all the formula in my
worksheet. I have looked through the help, and it has told me to select a
blank cell, go to the drop down menu Insert, choose Name and then Apply.
Then
to choose the name and click Ok.

I have done this but get the message 'Microsoft Office Excel cannot find
any
references to replace.' pops up.

The part of the formula i need to change is Parameters!$B$165 and i need
to
change it to Analysis_Period. I know i can do a find and replace, but i
would
like to know why the apply function isn't working.

Any suggestions?