George,

Define the name "print_area" and paste this formula where it says
"refers to". Repeat this for each of the six sheets - the column range
is dynamic based on row 8 as in your previous example:

=OFFSET($A$1,0,0):OFFSET($A$1,COUNTA($A:$A)-1,COUNTA($8:$8)-1)


Neill

PS - note that the value 0 is counted by the function COUNTA


--
neillcato
------------------------------------------------------------------------
neillcato's Profile: http://www.excelforum.com/member.php...o&userid=31750
View this thread: http://www.excelforum.com/showthread...hreadid=514952