BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.
These VBA code examples come from a personal collection that I reference frequently.