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" <(E-Mail Removed)> wrote in message
news:fdb60s$t4e$(E-Mail Removed)...
> 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.
>
>
>