View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kristen Kristen is offline
external usenet poster
 
Posts: 30
Default 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