Search for 6 Character value
Duhhhhhh. I can tell this has been a long week. Thanks
Marc
"Dave Peterson" wrote:
How about searching for ?????? (6 question marks)
* means any set of characters
? a single character
Make sure you specify lookat:=xlwhole in your code.
MFINE wrote:
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
--
Dave Peterson
|