Unreachable public variables

I define a group of public variables. I have a macro that initializes them.
They work fine through all my functions and subs. I have not found a way to
get my formulas in cells to see them. For example =A1*pi won't work. My
workaround has been to stick the value of pi in a cell and use a named range.
What's the real solution to using public vaiables in cell formulas??
--
Gary's Student
.

Loading