I am needing to loop through a series of cells and search for a criteria. The criteria could be something like 'C172' and I want to add that whole row to a range if the cell contains even just the 'C' part or just the '1' part etc. Is there a way to do a wildcard search in vba like
If Range("A:1").Value = "C*" so that I can do something if the value of the cell starts with 'C'?
This message was edited by fly2079 on 2002-02-19 07:56
If Range("A:1").Value = "C*" so that I can do something if the value of the cell starts with 'C'?
This message was edited by fly2079 on 2002-02-19 07:56