The second in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.

The first in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.

It is highly recommended that values that are passed into formulae, subroutines and functions are variables. However what if the value of that variable does not change? There is a way to make it immutable by declaring it as a constant.

Last weeks’ blog examined the value of declaring variables. But variables can also be used in different subroutines and functions. If there are items that are known to have constant values throughout the entire workbook, they can be declared explicitly in one place...

Take an in depth look of the good coding practice in declaring variables how it helps write better VBA code.

Last week we spoke about ranges and how you can refer to them in different ways. This week, we’re going to look at some of the ways you can apply range modifiers to change what set of cells exactly you’re referring to.

There are a number of different ways that we can refer to Excel cells in a worksheet. In the VBA blog series, we’ve been using a fairly consistent approach to referencing cell ranges – that is, using the Range object available in VBA.

It’s a great feeling when you write an involved piece of code with grand loops that apply over thousands of rows. There’s a sweet sensation when you save the file, hit run, and watch your handiwork unfold in front of you… until the screen stops updating...

Today we learn how to make something happen when you click on a cell...

This month is Event month! Today, we’re going to be looking at how to set up events to trigger on saving a file.