Please note javascript is required for full website functionality.

VBA Blogs

VBA Blogs: Going Through the Visual Basics – Part 4

24 August 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the basic principles of VBA.


VBA Blogs: Going Through the Visual Basics – Part 3

17 August 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at actually recording a macro.


VBA Blogs: Going Through the Visual Basics – Part 2

10 August 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This second part looks at how to record a macro.


VBA Blogs: Going Through the Visual Basics – Part 1

3 August 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This first part starts with the most basic of Visual Basics


VBA Blogs: Stop Reticulating Splines - Part 2

13 July 2018

More VBA optimisation tricks so you can stop reticulating splines.


VBA Blogs: Stop Reticulating Splines! - Part 1

6 July 2018

VBA Blog about improving calculation speeds.


VBA Blogs: Op-TRIM-isation

22 June 2018

One thing a regular coder always has to consider is optimisation. Code optimisation is the process of modifying code to improve quality and efficiency. By looking doing code optimisation, programs can become more lightweight in size, consume less memory, execute more rapidly and perform fewer operations.


VBA Blogs: Find The Right Format

15 June 2018

It’s easy enough to get on a cell’s case as we explored last week, but what if we wanted to find a cell that is formatted in a particular way?


VBA Blogs: Matching the Case

8 June 2018

Last week we used the LookAt parameter with the Find method to match the complete word. This week we look at case.


VBA Blogs: Finding the Part of a Whole

1 June 2018

Last week we looked at using the After, SearchDirection and SearchOrder parameters of the Find method.


Newsletter