Hello,
This code is not working for me and it doesn't give me errors:
Selection.Replace What:="#ˇREF!", Replacement:="a25", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ SearchFormat:=False, ReplaceFormat:=False
In the selected range i have GetPivotData formulas wrong referenced.
If I perform the Find & Replace in excel it works fine.
Any Ideas? Maybe an alternative solution
Thanks in advance,
cactus.-