View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brym brym is offline
external usenet poster
 
Posts: 13
Default Syntax for variable search

I've narrowed it down with this change:

Dim a, b, c As String

a = "("
b = "?????"
c = ")"
FindWhat = a & b & c

...and changed the line:

Pos = InStr(ActiveCell.Value, a)

But then I'll have to know how many digits in the number beforehand.