Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I repeat rows at the top, except the last page? Wendigone Excel Worksheet Functions 3 May 22nd 08 09:43 PM
Macro to repeat 2 contiguous rows to top of each page jwmbem Excel Discussion (Misc queries) 2 March 9th 08 02:23 AM
macro to repeat non contiguous rows at top in Print jwmbem Excel Discussion (Misc queries) 2 March 8th 08 07:50 PM
Need rows to repeat Except for last page carrera Excel Discussion (Misc queries) 1 August 3rd 07 07:22 PM
Macro for Page Setup - Repeat rows at top epuk Excel Programming 2 April 1st 05 04:23 AM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"