Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
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,
VBA Code:
Sub Remove_Expect_To_Step()
With Sheets("Outbound FIDS").Range("D:D")
.Replace "EXPECT TO STEP // ", ""
End With
End Sub