Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro to repeat two rows at top of each page
I need a macro to repeat rows 23 and 24 at top of each page. I must use page
set up to add rows 3 &4 so can't use it for rows 23 and 24 as well. Please write macro as I would use it, using rows 23 and rows 24 to repeat at top of each page. thank you -- J Macho |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro to repeat two rows at top of each page
I have tried several different ways to get those five rows to print without
having to put them somewhere on the sheet in contiguous arrangement and it just won't do it. Even if you manually set two rows in the page set up, the VBA code will override what you put in because it uses the page set up to set the rows to print also. Looks like you will have to do some cutting and pasting. "jwmbem" wrote: I need a macro to repeat rows 23 and 24 at top of each page. I must use page set up to add rows 3 &4 so can't use it for rows 23 and 24 as well. Please write macro as I would use it, using rows 23 and rows 24 to repeat at top of each page. thank you -- J Macho |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro to repeat two rows at top of each page
Whiz,..thanks mucho..so far cut and paste is it but it stays on page one as
well..many thanks -- J Macho "JLGWhiz" wrote: I have tried several different ways to get those five rows to print without having to put them somewhere on the sheet in contiguous arrangement and it just won't do it. Even if you manually set two rows in the page set up, the VBA code will override what you put in because it uses the page set up to set the rows to print also. Looks like you will have to do some cutting and pasting. "jwmbem" wrote: I need a macro to repeat rows 23 and 24 at top of each page. I must use page set up to add rows 3 &4 so can't use it for rows 23 and 24 as well. Please write macro as I would use it, using rows 23 and rows 24 to repeat at top of each page. thank you -- J Macho |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat Rows but not on every page! | Excel Worksheet Functions | |||
Macro to repeat 2 contiguous rows to top of each page | Excel Discussion (Misc queries) | |||
macro to repeat non contiguous rows at top of ea page | Excel Programming | |||
Rows to repeat at top Except for the last page | Excel Programming | |||
Macro for Page Setup - Repeat rows at top | Excel Programming |