Search for 6 Character value

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
 
D

Dave Peterson

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Formating bolded text exclusively. 0
Search cell value in same column 3
Macro to search for a value on multiple tabs 0
search for special character in different fonts 0
Converting URLs in comments to Markdown-formatted links 2
Look Up Formula With Veried Search Range 2
Find text in cell and copy from 4 characters in front of the found text. 2

Top