Barryj
07-13-2014, 10:23 AM
I have a find and replace macro in the attached work book that works fine except for when it has to find and replace the following #VALUE!
it bugs out on this line
myRange.Replace What:=cel.Value, Replacement:=cel.Offset(0, 1).Value
I have a find and replace formula that works fine as a comparison on the formula test page.
Even if there is nothing to replace on the Main Sheet the fact that #VALUE! is on the replace page caused the macro to bug out at the above line.
Any thoughts why this is happening would be appriciated.
Thanks
it bugs out on this line
myRange.Replace What:=cel.Value, Replacement:=cel.Offset(0, 1).Value
I have a find and replace formula that works fine as a comparison on the formula test page.
Even if there is nothing to replace on the Main Sheet the fact that #VALUE! is on the replace page caused the macro to bug out at the above line.
Any thoughts why this is happening would be appriciated.
Thanks