Remove specific Text (Missing one line)

[Livin404]

Greetings I have the following VBA works fine as long as I'm on the same worksheet when I activate it. I thought I identified the right sheet "Outbound FIDS", but I'm pretty sure I am missing one maybe two lines. I'm using a button on sheet "72 Hours". I need it to search for all cells with data in Column D. Thank you,

Sub Remove_Expect_To_Step()
 With Sheets("Outbound FIDS").Range("D:D")
     .Replace "EXPECT TO STEP // ", ""
     End With
End Sub

 

[Fluff]

That code should work regardless of what sheet is active.

 

[Livin404]

You're right, I forgot to add that particular Macro to the Run All "Call ….". That makes a big difference! Thank you

 

[Fluff]

Glad you sorted it & thanks for the feedback.