Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing constants
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not sure on constants | Excel Programming | |||
constants | Excel Discussion (Misc queries) | |||
constants | Excel Programming | |||
changing the constants in the find function | Excel Programming |