macro to repeat non contiguous rows at top in Print
 

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.



--
J Macho

macro to repeat non contiguous rows at top in Print
 

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

"jwmbem" wrote:

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.



--
J Macho

macro to repeat non contiguous rows at top in Print
 

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.


--
J Macho


"Sean Timmons" wrote:

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

"jwmbem" wrote:

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.



--
J Macho