Counting Range Automatically

There is an Excel file that teaches how to perform the Counting Range Automatically operation.

Excel Solution: Counting Range Automatically

This workbook demonstrates counting range automatically using VBA macros on a 1-row data layout.

Hope it is useful.