cactus
01-29-2010, 10:50 AM
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.-
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.-