how come the REPLACE() not working in 2010 Excel

[feipezi]

Hi,

The following code's been working for thousands times but I got runtime error "1004" as ran it on 2010 Excel. What can be wrong? I switched to R1C1 formula style and get the same thing. "1004" means something cannot be found. What the heck is it?

Thanks in advance.


Sub FixREF()
Sheets("ViewGraphs").Activate
Range("c151155,c192196").Select
For Each c In Selection
c.Formula = Replace(c.Formula, "#REF", "AreaMetrics!$A$1:$AD$1000")
Next
End Sub

 

[Andrzejek]

Go to Tools - References... and look for any references that start with the word:[tt]
MISSING ...[/tt]

Have fun.

---- Andy