Daniel,

Shouldn't it be $16: that is colon not semi-colon?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"dspilberg" wrote in message
...
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