Hi Group,
I am trying to find the position in a string variable to extract some
numbers. The string is (14)44, which is in a variable called WeekNo. I am
trying to extract the number with in the ( ), which can be one or two digits
long. I have tried using mm=application.worksheetfunction.find("(",WeekNo,2 )
to get the position, but this failed. I also tried
mm=application.worksheetfunction.find('(',WeekNo,2 ) and failed. Finding the
position is only an interim step to extracting the number and there may be an
easier way.

Thanks,
David