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