Your question is how to change constants. But if they are changing then they
are not constants. Constants are used for holding values that you never
expect to change. Pi is a contant. The number of hours in a day is a contant.
If you reasonably expect the value to change then store it in a user
accessable location in your spreadsheet and then read that value at run time,
similar to Ryan and Gary's suggestions.
--
HTH...

Jim Thomlinson


"electricbluelady" wrote:

HI Everyone,
When billing every month there are 'constants' that change. Currently, I am
trying to design a way where a user does not have to go into the program
every month to change 'constants'. Is there a way to refer to a cell as a
'constant'? This is what I have so far....

Const D37 as Long = 10000.
Next month D37 may be 11000. The number is entered into the spreadsheet, but
the macro runs formulas off of the declared constant in the macro.

Thanks again. :)
--
Thank you,
Electricbluelady