Hi, I'm using VBA to write a macro to generate some data onto an excel worksheet.

i have resized all columns such that everything will fit into the width of 1 A4 size paper. I have a row of headers on Row 1 to name each column. i.e. Col A can be 'Name', Col B can be 'Telephone' etc.
however, they can be like 100 rows of data in the worksheet thus it will stretch to be printed onto 5 sheets of paper.
as such is there a way to program in VBA that allows the headers of Row 1 to appear at the top of each new paper that will be printed?

pls advise.