| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indicating Rows to Repeat At Top on all Worksheets Simultaneously
Is there a way to do this? I have Excel 2000. Thanks!!
-- Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/ More information at http://www.talkaboutsoftware.com/faq.html |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indicating Rows to Repeat At Top on all Worksheets Simultaneously
Nope.
Maybe you could record a macro when you did it for one sheet and then just rerun that macro for the other sheets (or modify it to do all the sheets). Lilbit wrote: Is there a way to do this? I have Excel 2000. Thanks!! -- Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/ More information at http://www.talkaboutsoftware.com/faq.html -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indicating Rows to Repeat At Top on all Worksheets Simultaneously
Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets. For anyone interested in the code see this google search result with Dave Peterson and myself posting. The print area code is from Bob Flanagan. http://snipurl.com/106kz Gord Dibben MS Excel MVP On Fri, 23 May 2008 10:14:31 -0500, "Lilbit" wrote: Is there a way to do this? I have Excel 2000. Thanks!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indicating Rows to Repeat At Top on all Worksheets Simultane
Thank you very very much Mr. Dibben. It worked perfectly!!!
-- Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/ More information at http://www.talkaboutsoftware.com/faq.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
| How can i repeat certain rows in all worksheets in an excel file | Excel Discussion (Misc queries) | |||
| Add a Row to Multiple Worksheets Simultaneously | Excel Worksheet Functions | |||
| View worksheets simultaneously | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Hybrid Mode
