Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.
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, 9 Jan 2009 12:41:10 -0800, jggsfl
wrote:
How do I copy print area to multiple worksheets?