Error when using a formula as a macro even though the formula works..

[Hyflex]

Hey, I have a formula which I have tried to turn into a macro and it's not working I get an error but the actual formula works if I put it in manually...

Formula Version:

Please Login or Register  to view this content.

Macro Version:

Please Login or Register  to view this content.

Any ideas of how to fix this?

[tigeravatar]

Hyflex,


Formula can be shortened to:

Please Login or Register  to view this content.

Macro version:

Please Login or Register  to view this content.