200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
hello
I have this code
Sub clear_part()
With Range("B2", Range("B" & Rows.Count).End(xlUp))
.Replace " Purchase Order*", "", xlPart, , False, , False, False
End With
End Subit doesn't work anymore . should clear item contains Purchase Order for each cell in column B .
anybody find out what's the problem , please?
Leopard
Your code will clear all cells starting with a SPACE then "Purchase Order" (since the wildcard * will cover any text following that).
Suggest your remove the leading space or asterisk * in the " Purchase Order*" part of your code.