VBA

Your code compiles perfectly and has worked thousand of times before, but suddenly it starts giving you a nasty error message: ‘Code execution has been interrupted’. It looks like the one you get when you press Ctrl-Break or when your code produces an error which you haven’t trapped, but it isn’t either of those ...

This is a list of the sorts of things that can be done using VBA as far as Office 2016 is concerned. I’m now on Office 365, so there may be slight differences in coding techniques for some of these things: I’ll update this note as I find them. This is certainly not an exhaustive ...

Save your workbook before you proceed any further. If you’re using Excel 2007, you’ll need to make sure it’s saved as a macro-enabled workbook (*.xlsm). Keep this copy as a backup: VBA code can be extremely destructive and there’s no Undo facility to fall back on! Select Developer > Visual Basic from the Excel ...