Search for 6 Character value

  • Thread starter Thread starter MFINE
  • Start date Start date
M

MFINE

Hi, I am trying to design a macro that will search for values in a column
that are 6 characters long. Data is text that looks like numbers (downloaded
from a mainframe). I tried using a search with 6 *'s but it just returned
everything.

Any suggestions?

Thanks

Marc
 
How about searching for ?????? (6 question marks)
* means any set of characters
? a single character

Make sure you specify lookat:=xlwhole in your code.
 
Back
Top