Equivalent Worksheet Formula to VBA Formula

[cgkmal]

Hello to all,

I have this formula that works fine,

Please Login or Register  to view this content.

but I want to know if it is possible to write an equivalent formula using VBA formulas like this:

Please Login or Register  to view this content.

Because if I use Evaluate() method, I cannot use it variables like below:

Please Login or Register  to view this content.

Thanks for any help.

[Jonmo1]

Just a guess because I can't see how those variables are defined...

But Perhaps you need to use
MyRange1.Address in the Evaluate...

[cgkmal]

Hello Jonmo1,

It seems adding .address does the trick.

Many thanks for your help

Regards