Excel specification and limitation

Before getting serious in our coding it is better to know detail specification and limitation of Excel Workbook and Worksheet. For example:

Total Number of Rows : 1,048,576
Total Number of Columns : 16,384
Column width : 255 characters
Row Height : 409 points

All these data will help us to decide what data type to use for example when we work with rows then we use long and column integer is enough and etc. This also help us to prevent error and our code more accurate. For more detail please refer below link.

Microsoft Reference-Excel-specifications-and-limits

Practice makes perfect. Thank You.

macro enabled excel
excel macro
vba coding
vba code