Replace part of formula VBA

[Testnntest]

Hi all,
I would like to construct a macro that will search through all formulas in a coulmn and replace a given value #REF! with another value CP69!

I get no errors when I use the code below, but nothing happens to the formulas either.

Please Login or Register  to view this content.

[AB33]

I have tested it and works

Please Login or Register  to view this content.