You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

Excel and other MS Office applications make extensive use of enumerations - and you should too!

This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.