I have tried selecting all the cells containing the formula to change, and as
i mentoned I used the help function which told me to select a blank cell to
change the entire worksheet. Neither of which works for some reason.

"Tyro" wrote:

You have to select the range(s) that contain all of the formulas that refer
to the cells in the named range before you do the apply. Excel is looking in
your selection for formulas to change. You chose a blank cell. Nothing to
change there.

Tyro

"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?