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"