I have created a range, such that the columns within the range extend as
time progresses - i.e. in July, you only see columns of up to and
including July information.
When I enter the range name in the page setup - define print area
dialog box, and do print preview, the correct area is set as print
area. However, I want the print area to automatically update when we
move onto the next month, and when I return to page setup, the range
name is lost, replaced by the cell references of the range.

Any ideas how to keep that print area as a range?

Thanks,

Steve


--
stevepain
------------------------------------------------------------------------
stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759
View this thread: http://www.excelforum.com/showthread...hreadid=388412