macro to repeat non contiguous rows at top of ea page
 

-- 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 of ea page
 

In less than a minute, I've seen this question posted three times. You don't
need to multipost. People will answer when they can, not on your schedule.
Be patient and you should get a response.
--
HTH,
Barb Reinhardt



"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 of ea page
 

Sorry my first time using this site and it said message was blcoked..but it
wasn't ..
--
J Macho


"Barb Reinhardt" wrote:

In less than a minute, I've seen this question posted three times. You don't
need to multipost. People will answer when they can, not on your schedule.
Be patient and you should get a response.
--
HTH,
Barb Reinhardt



"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