And where do these headings come from?

When in the code sequence do they get copied?

Post your code.


Gord

On Tue, 20 Dec 2005 16:20:02 -0800, "wil4d"
wrote:

The heading is different for every page

"Gord Dibben" wrote:

Not clear from your description what needs doing.

Is the heading description the same for each page or is it different on each
page?

Post your code and maybe we can figure out where to place a pagebreak command.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 15:10:03 -0800, "wil4d"
wrote:

I have a Macro that hides and copies visible cells to worksheet 3, but, I
have a certain row (the heading description for the next page) that needs to
wait till the next page break befor copying so that I don't have to manually
adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there
is a way it would really save me.