Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Variables and arrays in VBA macros blogs

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.

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.