Notwithstanding that Excel has a PI() function, if you want worksheet
constants like that, create a workbook name with that name and the required
value.

--
HTH

Bob Phillips

"Gary's Student" wrote in message
...
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