Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to repeat 2 contiguous rows to 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.misc
|
|||
|
|||
Macro to repeat 2 contiguous rows to top of each page
The easiest way is to pull the values from rows 23 & 24 to rows 5 & 6.
A5: =A23 B5: =B23 A6: =A24 B6: =B24 etc. You can hide these rows until you are ready to print. You can use a simple macro like the following to unhide rows 5 & 6 and set rows 3:6 as your print titles. Sub Macro1() Rows("5:6").EntireRow.Hidden = False With ActiveSheet.PageSetup .PrintTitleRows = "$3:$6" End With End Sub Hope this helps, Hutch "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.misc
|
|||
|
|||
Macro to repeat 2 contiguous rows to top of each page
Thanks Tom will give it a shot!
-- J Macho "Tom Hutchins" wrote: The easiest way is to pull the values from rows 23 & 24 to rows 5 & 6. A5: =A23 B5: =B23 A6: =A24 B6: =B24 etc. You can hide these rows until you are ready to print. You can use a simple macro like the following to unhide rows 5 & 6 and set rows 3:6 as your print titles. Sub Macro1() Rows("5:6").EntireRow.Hidden = False With ActiveSheet.PageSetup .PrintTitleRows = "$3:$6" End With End Sub Hope this helps, Hutch "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 | |||
macro to repeat non contiguous rows at top in Print | Excel Discussion (Misc queries) | |||
Need rows to repeat Except for last page | Excel Discussion (Misc queries) | |||
ROWS TO REPEAT ON EACH PAGE | Excel Worksheet Functions | |||
Rows to repeat on each page | Excel Worksheet Functions | |||
How can you get different rows to repeat on each page | Excel Discussion (Misc queries) |