Marking Range Automatically

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

Excel Solution: Marking Range Automatically

This workbook demonstrates marking range automatically using VBA macros on a 59-row data layout.

Hope it is useful.