is it possible to have multiple title rows print using vba?

for example, assume that rows 1 through x have column titles "rep" and
"productivity" and that rows x+7 through y have column titles "manager" and
productivity. is it possible to print the "rep" and "productivity" title
rows on each page and then page break, and then print the "manager" and
"productivity" title rows going forward?