Insert Page Breaks using Excel VBA

In this video, we create a macro to insert page breaks before rows that contain headers automatically. If you want to learn Excel VBA fast. Enrol in our online course - http://bit.ly/37XSKfZ I was asked a question from a reader recently who had a large list in Excel. They needed to insert many page breaks at irregular intervals. There was a heading though that marked the start of a new page. The task was to create a macro to insert all the page breaks at the click of a button. This video talks through the VBA to insert page breaks, and how that was used to solve this question. The timings for the video are; 00:00 - Introduction to the task 01:34 - Find out how many page breaks are required 02:54 - A look at the existing VBA in the project 04:52 - Excel VBA to insert page breaks 05:56 - Running the macro to test it. 06:42 - Closing words Find more great free tutorials at; https://www.computergaga.com