Arrays & Performance
Pull a whole range into memory, do the work there, and write it back in a single line — hundreds of times faster.
The first lesson is free — no account needed.
About this course
Cell-by-cell loops are why most macros are slow. With VBA arrays you read a whole range into memory, do the work there and write it back in a single line. The course also covers the Application switches, measuring with Timer and the common traps, ending with a working template.