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.