Thread: Selection Replace

Hi,

I'm having a problem with Selection Replace in a macro.

I am tryiong to replace 06 Jun with 07 Jul, I have DIM statements for LMNo = 6 LM = Jun and TMNo = 07 and TM = Jul.

The macro runs through okay but nothing changes?

Selection.Replace what:=("0" & LMNo & " " & LM), Replacement:=("0" & TMNo & " " & TM), LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False