Find and replace

[JARichard74]

Very simple code but can't figure out why this one works

If ThisWorkbook.Worksheets("Prep").Range("E5").Value = "English" Then
    ThisWorkbook.Worksheets("All").UsedRange.Replace What:="Majoration", Replacement:="Markup", LookAt:=xlWhole
    Else
    ThisWorkbook.Worksheets("All").UsedRange.Replace What:="Markup", Replacement:="Majoration", LookAt:=xlWhole
    End If

But this one does not

If ThisWorkbook.Worksheets("Prep").Range("E5").Value = "English" Then
    ThisWorkbook.Worksheets("All").Range("J1:DZ200").Replace What:="Majoration", Replacement:="Markup", LookAt:=xlWhole
    Else
    ThisWorkbook.Worksheets("All").Range("J1:DZ200").Replace What:="Markup", Replacement:="Majoration", LookAt:=xlWhole
    End If

I want to do the find and replace from column J onward

 

[mrshl9898]

The second works fine here... Can you share the workbook?

 

[JARichard74]

The second works fine here... Can you share the workbook?

Bunch of macros interacting with each other might have been using the wrong active workbook. Seems to be working. Thanks for quick reply