tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
hi everyone,
this seams a simple bit of code but it bugs out everytime
anyone know why this bit of code does not work its just a find and replace
this seams a simple bit of code but it bugs out everytime
anyone know why this bit of code does not work its just a find and replace
VBA Code:
ActiveWorkbook.Sheets("ordersSheetName").Columns("M:M").Replace What:="Choose Sauce:*", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2