Dec 10, 2020
Difference between ByVal and ByRef in VBA
When you design a procedure in VBA you may want to pass some data values to it for processing. You pass data through arguments; like a and h below on lines 6 to 8; [...]
Jul 07, 2020
Autofill to the Last Row Using VBA
Sometimes you require imitating the operation of Autofill to the last cell in Excel VBA. This is when you double click the little dot located at the right bottom corner [...]
Jun 18, 2020
For Each loops in Excel VBA
Unlike the traditional For Next loops, the For Each loops do not iterate a ‘set’ number of times. Simply put, this looping structure allows you to iterate through a [...]
May 29, 2021
Recursive functions in VBA
In programming, you use functions for two purposes. You either want to reuse a piece of code over and over again, therefore you encapsulate it as a function, or you may [...]
Dec 09, 2020
Change the Spell Check Language on all slides in PowerPoint using VBA (2007 onwards)
One limitation of PowerPoint is that you can only change the Spell Check Language for a one text box at a time; there is no way to set it for the entire presentation. [...]
Sep 30, 2020
Customise the Ribbon in an Excel workbook
We all know how to customise the Ribbon in Microsoft Excel by using the graphical user interface, but the problem with this way of customisation is that if you move the [...]
Aug 08, 2020
Easily delete blank rows from your data using Excel VBA
Quite often, you'll be required to remove non-contiguous blank rows to join ranges of data together. This is quite tricky to do in Excel, but I've explained how to do [...]
Jul 17, 2020
Remove blank rows in Excel with this VBA code
Quite often, you will find that you may have several table ranges in your Excel worksheet separated by blank rows that are undesirable. You also might even have a big [...]
Jun 30, 2020
How to populate tables in Excel VBA
There may be occasions where you need to populate an existing table with more data, and in such occasions, the first thing you would generally think would be "Where [...]
May 26, 2021
VBA Excel: Finding the last row of a worksheet (Part 2)
In my last blog post, VBA Excel: Finding the last row of a worksheet (Part 1), I explained how to use the control arrows to find the last row of a worksheet in VBA [...]
May 15, 2021
VBA Excel: Finding the last row of a worksheet (Part 1)
When creating macros in Microsoft Excel, you often want to find the last row of data in a worksheet to be able to choose the correct area so the macro can do things with [...]
May 01, 2021
How to access Office Applications from within VBA
Did you know you can access and manipulate any Office application from within Visual Basic (VB) code? In today's blog post, we'll go through the basic steps to connect [...]
