Multiple print areas

[Dave]

Hi

I need some help of printing if possible.

I currently have a worksheet whcih contains a page of
graphs and then underneath a page of data. The layout of
the graphs and data is such that the data occupies more
columns & rows than the graphs, but when I print them both
out, I need them both to be the maximum size on the page.

At the moment, the only way I can do this is to set the
page setup properties to "fit to 1 wide and 1 tall", and
then manually set the print area of the graphs and the
print, then set the print area for the data and then print.

What I am after is a way of settig the sheet to have
multiple print areas, so that when I press print, it
automatically sets the areas of the graphs and data, and
ignores the miscellaneous workings elsewhere on the
spreadsheet. I know how to do this by recording a macro of
me doing this manually, and then initiating this via a
button, but I dont like doing it this way.

Any help would be appreciated.

Thanks
Dave

 

[Don Guillett]

You can put an automatic macro in the Beforeprint event in the ThisWorkbook
module.