Blogs from Wise Owl on Variables, arrays in VBA macros

Showing blogs 1-3 (out of 3)

How to use environment variables like USERNAME in VBA

Posted by Andy Brown on 25 November 2013

You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.

Tags:   VBA macros | Variables, arrays    |    Writing VBA | Other

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012

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

Variables and Constants in Excel Visual Basic

Posted by Andy Brown on 05 September 2011

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.

This page has 0 threads Add post