Blogs from Wise Owl on Variables, arrays in VBA macros

Showing blogs 1-3 (out of 3)

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012 | no comments

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

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012 | no comments

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

Variables and Constants in Excel Visual Basic

Posted by Andy Brown on 05 September 2011 | 6 comments

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.