Named Range to store variable for use by other macro on other days

[Alexander40]

Hello,
I am trying to use Named Ranges .value property to store variable info so that I can use that variable when needed by other macro's on other days. The code looks like:

Please Login or Register  to view this content.

If I refer to the "Active_Indicator" it would return a value of "=x" minus the quotes. I just want to get the x without the equals sign. I am using .value, Not .RefersTo. I could use a Right minus 1 from the length but I was just hoping to get it cleaner than that.

Any thoughts?

Regards...

[PCI]

With next statement it seems it could be good
You could adapt it to your need

Please Login or Register  to view this content.