You need to define your print range, if it is the same, re-record your
macro and while recording select and set your print area.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=477618