Re: Simple replace command

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <dspilberg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2EDD5C1-DF10-4845-BA0C-DCE55AD846D4@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Selection.Cells vs Range reference - strange behaviour (using
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... parentheses to indicate the parameters to be passed. ... I have a series of subs for formatting text along the lines of ...
    (microsoft.public.excel.programming)
  • Re: Help with SUMIF
    ... It worked because any non-zero value is TRUE, so for the odd columns *1 ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... "Bob Phillips" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A bit more help needed on an =SUMPRODUCT if possible?
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Try posting the data with some cell character to show where they change, ... GD and a separate monthly readout for analysis purposes... ...
    (microsoft.public.excel)
  • Re: Formula to get sum from one 31 sheets to a summary sheet.
    ... "Bob Phillips" wrote: ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... This is brand new to me, please forgive me if my related communication is ...
    (microsoft.public.excel.misc)
  • Re: visual basic error
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... ' AvgRounds Macro ... Dim total_plays As Byte, used_plays As Byte ...
    (microsoft.public.excel)