Forcing Class Properties to do More Work

Class properties are typically simple statements which serve the basic purpose of reading or writing data in custom objects. However, it is possible to add additional lines of code, giving properties features similar to standard subroutines or functions.

Speed Test: VBA Range Object

It’s worth taking a deeper look at the Range object, as it is a central element to reading, writing, and modifying data on a worksheet. This post uses a classic speed test to time the most efficient method of interacting with a spreadsheet.