anyone know why this bit of code wont work on excel 2019?

[tonywatsonhelp]

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

ActiveWorkbook.Sheets("ordersSheetName").Columns("M:M").Replace What:="Choose Sauce:*", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

 

[johnnyL]

I would suspect the problem is the ', FormulaVersion:=xlReplaceFormula2'

Try removing the '2' off the end of it or remove the ', FormulaVersion:=xlReplaceFormula2' completely.

 

[tonywatsonhelp]

OK thank you

 

[johnnyL]

Which method worked for you?