Indicating Rows to Repeat At Top on all Worksheets Simultaneously

[Lilbit]

Is there a way to do this? I have Excel 2000. Thanks!

-
Message posted using http://www.talkaboutsoftware.com/group/microsoft.public.excel.worksheet.functions
More information at http://www.talkaboutsoftware.com/faq.htm

 

[Dave Peterson]

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).

 

[Gord Dibben]

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

 

[Lilbit]

Thank you very very much Mr. Dibben. It worked perfectly!!

-
Message posted using http://www.talkaboutsoftware.com/group/microsoft.public.excel.worksheet.functions
More information at http://www.talkaboutsoftware.com/faq.htm