VBA Productivity Tip: Intellisense

This post introduces our first VBA Productivity Tip, a summary of the VBA Editor’s intellisense feature. Intellisense can help reduce the occurrence of common syntactical and semantic errors by providing useful tooltips and lists to help you code more efficiently.

Overview of Methods and Properties of the Range Object

When coding in VBA, the range object offers a means to fully interact with cells on a spreadsheet. This is done through its object methods and properties — nearly every action undertaken in the Excel interface has a equivalent method or property in VBA.