Excel is a mighty powerful application, and yet, there are any number of utilities available to extend its capabilities. I’m sure everyone has their favorites, and here I’m going to talk about mine. My reliance on these utilities is as a developer of Excel applications, that is, solutions that combine add-ins, templates, and regular workbook [...]

When working in the Visual Basic for Applications Integrated Development Environment (VBIDE, or “VB Editor” for short), you can choose a number of settings to make your programming experience better. I’ll show the settings I use along with my rationale for choosing them.
First, go to the IDE’s Tools menu, and choose Options, to bring up [...]

In a recent post, I showed how to record a macro to save yourself time and effort with that repetitive task. The recorder has captured all of your keystrokes, intentional and otherwise. Objects are selected first, then acted upon. Defaults are applied indiscriminately every time the recorder followed you into a dialog. Actions you take and undo [...]

In a recent post, I showed how to copy someone else’s VBA procedure (i.e., “macro”) and paste it into your own workbook. Fortunately you don’t have to rely on others for custom macros. Excel includes a Macro Recorder which captures your actions, so that you can replay them later, saving yourself time and keystrokes.
It’s easy [...]

This is the first in a series of How To posts that are targeted at Excel users who are unfamiliar with VBA programming. Topics will include
Using someone else’s macro
Recording your own macro
Fixing a recorded macro
Assigning a macro to a button or shape, ActiveX button, or menu or toolbar
VBE settings
VBE features
Debugging and error proofing
Suppose you [...]