Object Oriented Programming: What is it?
Object Oriented Programming can be described as a programming style. VBA uses the OOP model which focuses on influencing objects, methods & properties.
Visual Basic Editor (VBE): The Home of all Excel Macros
The Visual Basic Editor is the environment in which all Excel Macros reside. If you’re writing or editing VBA, this is the place to start.
Color Row of Selection using VBA
I’m sure you’re no stranger to an Excel trackers. How many milliseconds a year do you spend…
VLOOKUP Error messages and how to eliminate them
So your fancy VLOOKUP is returning an error message. Let’s understand what these errors mean and how to deal with them.
How to use Excel VLOOKUP
VLOOKUP can search a table of data (first column only) for a variable and, if a match is found, return a piece of data from that matching row.
Page 1 of 1