macro to repeat non contiguous rows at top in Print

J

jwmbem

I am a pure novice with Excel 2007. I only have one work sheet I work
with. I need a macro to place rows 3,4,5,23,and 24 at the top of every
succeeding page following page one. They show up only in Print. Page setup
won't work as the rows must be contiguous.The data in each of these rows must
remain as each successive page header is to be the exact duplicate.Coulde you
please write the macro exactly as I should copy to VBE.
 
S

Sean Timmons

I'm pretty sure this can't be done. You can always go into View - Header and
Footer, select Custom and start typing.
 
J

jwmbem

You might be correct. How about this then: how about repeating a row with
existing text on every page automatically and the I can use the page set up
to add theother non contiguous rows in print? Can you provide me with the
macro to rrepaeat the rows automatically. They would be rows 23 adn 224.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top