Print after using macro to fill worksheet

Hello, bit of a strange one. Hopfully easy for someone.
I am using some code that automatically retrieves a list of data using a cell value as a search criteria and then it populates my worksheet with all the relevant data I require. The problem I have is when it comes to printing. Because the data has been added via code/macro the print are does not automatically expand to include all the data (eg if you look in page break view, it has not moved to include the data added as it would do if the data was added maually)?
The data inserted could be upto 100 pages long, but when I try to print it the page break is only part down page 1 and I then need to manually drag it down????
Is there a way around this in the code? Has it got something to do with EnableEvents?
The code in question is:

Please Login or Register  to view this content.