When you first start out using VBA and writing VBA (macro) code it is useful that the VBA Editor helps you quickly identify when you have made a mistake. If a line of code has an error it will display a dialog box that explains the error and turns the line of code red.
Selecting rows and columns
You can use the keyboard to quickly select whole rows or columns.
To select a whole column, or columns, use:
Ctrl + Space
To remember this shortcut – both Ctrl and column start with C.
To select the whole row, or rows, use:
Shift + Space
To remember – s and r are next to each other in the alphabet.
Creative minds have been known to survive any kind of bad training.
In a previous blog post I explained how to do a 3D SUM calculation in Excel that SUMs through sheets. You can view it here. I have seen a few posts in forums recently about performing a 3D SUMIF calculation. Whilst the SUM function can work with 3D ranges, the SUMIF function can’t.