I have a macro that deals with 9 different files one by one.
I have 2 columns in each file that should have its formulas' references
adapted depending on the file I am treating.

I used the replace comand, but it's not working. I tried several times and
several ways... I just wanted to replace "$16;" by "$17;", "$18;",... etc
which are filed in the variable substitution.

If one has a tip... Thanks in advance,

Daniel (Brazil)

myUnion.Select

myUnion.Replace What:="$16;", Replacement:=Substitution, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False