excel-vbaExcel-VBA Optimization


Introduction

Excel-VBA Optimization refers also to coding better error handling by documentation and additional details. This is shown here.

Remarks

*) Line numbers represent are integers, that is a signed 16 bit data type in the range of -32,768 to 32,767, otherwise you produce an overflow. Usually line numbers are inserted in steps of 10 over a part of the code or all procedures of a module as a whole.