Copy & Paste Row After Page Break

  • I have a report that I run several times a day and I need to format it in excel. I have got my VBA macro working almost right but I have a few things I cant figure out


    I have pasted my macro with notes in the places I need help. I need to copy row one and paste it after every page break so that it ends up at the top of each page. I also need to fill K2 and L2 down to the last row after inserting the formula in K2



    Thank you for any and all help

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too.

  • I have gotten my code working almost perfectly thanks to help from dangelor. The only issue i have now is when it prints the file, it prints one page with just the top row because that is where the first page break is. I have attached my new code if anyone could please help me.