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)

"Sing" wrote in message
...
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.

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.
--
HTH...

Jim Thomlinson


"Sing" wrote:

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.