What is the #define equivalent?

  • Thread starter Thread starter Sing
  • Start date Start date
S

Sing

Dear Excel Gurus,

In C, one can make convenient definitions like;
#define ABC 242
#define NAME "James Smith"

In Excel VBA, is there an equivalent for #define?

Thanks.
 
Const

say

Const ABC as long = 242

Const NAME as string = "James Smith"

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
VBA does not have a preporcessor the same as C does. What you have posted are
just constants which are handled, but if you wanted to get into defining
formulas and such then you are out of luck.
 
Back
Top