View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
electricbluelady electricbluelady is offline
external usenet poster
 
Posts: 10
Default 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