Category Archives for "VBA"

How to Avoid the Select Method in VBA & Why

The first TV I remember us having as a kid did NOT have a remote control.  How inconvenient, right?

Every time someone in the family wanted to change the channel or volume, we had to get up off the couch and walk over to the TV to press a button.  You didn’t want to be the one sitting closest to the TV unless you needed some exercise… 🙂

The Select Method is Like Using a TV without a Remote Control

Continue reading


Intro to VBA: Reading, Writing and Running Code (Part 3 of 3)

A Tip for Reading a Line of Code – Go Backwards

When you are learning to write code, it’s best if you know how to read it.  Sometimes you’ll see a long line of code with a lot of dots and think, “what does that mean???”

I find that reading code backwards helps.  Start with last word and work your way left, replacing the dots/periods with the words, “of” or “of the”.

Reading VBA Code Backwards - Intro to VBA

Continue reading