Let's say the value for D37 is already being entered in Sheet1, cell D37. In
VBA:

Sub dural()
Dim D37 As Long
D37 = Sheets("Sheet1").Range("D37").Value
End Sub

--
Gary''s Student - gsnu200793


"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