Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the wildcard with IF | New Users to Excel | |||
If and wildcard | Excel Discussion (Misc queries) | |||
Wildcard | Excel Programming | |||
Wildcard | Excel Programming | |||
Wildcard | Excel Programming |