Using Wildcard in VBA IF
Thanks for any assistance you can provide. I have looked and can't seem to
find the answer and I don't think it should be that hard.
I have a column that has some text cells that start with "PO....". I would
like to replace all cells in that column with "" or delete the contents. I
thought just replacing with "" would be easiest. I have tried using * and ~
as wildcards. Neither is working
Here is what I was trying to use:
Range("a2:a98").Replace What:="P*", Replacement:=""
--
Thanks - K
|