If they enter it that way and Name1 is meant to refer to a defined name on
the worksheet, then I think you would have to parse it out and resolve it.

--
Regards,
Tom Ogilvy


"Peter" wrote:

It is because user won't enter a string like:
MyName = '" & Range("Name1") & "' AND ....

but they'd enter : MyName = 'ABC' AND AnotherName = '" & Name1 & "'"...

So I still have to parse the input and transform to a proper format, or am I
think in the wrong way?

THanks