"Glenn" wrote in message
...
T. Valko wrote:
Do each of you have any comments as to which is preferable?

Well, of course I think my suggestion is preferable! <g

I don't know exactly what your UDF is doing other than extracting part of
a string, but, based on which string and under what conditions, so I
can't comment on Glenn's approach.

You said the string "Current Price nnnnnn" may appear many times in your
range so I don't know which instance of that string you're interested in.




Actually, the OP stated...

"There will only be one such string in the Data Sheet daily"

Yeah, that's the one instance their UDF has extracted. Where is this
instance of the string in the "raw data" and which one does the UDF extract?

--
Biff
Microsoft Excel MVP