Inserting Page Breaks in Existing Macro

Good Morning,

I am seeking assistance expanding an existing macro that John previously helped me with. It works very well but to make the data more usuable I would like to insert a page break after every series of number. Example: After all the number 0's are found then sorted onto sheet2, insert a page break. And do the same up to number 9. This will allow me to print out evaluate each set of numbers separately. Please see sheet1 and sheet2 on attached spreadsheet named Testing 2.2.xlsm

Thank you

Donald

Hi Donald
Try adding the following line in the procedure "TestFindAll"

Please Login or Register  to view this content.