Thread: Find Command
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1436_] Rick Rothstein \(MVP - VB\)[_1436_] is offline
external usenet poster
 
Posts: 1
Default Find Command

Can you give us an example of some of the more complicated "patterns" you
are trying to locate the position of?

Rick

"RLang" wrote in message
...
Hi,
I've used the FIND command in conjunction with wildcard characters to
find string patterns in a worksheet cell. Can anyone tell me if I can do
the
same thing in VBA against a string variable that I've read in from a file
rather than referencing a cell? Apparently INSTR doesn't allow wildcard
characters.

Thanks much.