QUESTION - Printing based on number of columns

[maddog9486]

I tried doing some searching on this and i know you can control a lot of printing using vba, but what i can't seem to find is how to set the print area based on the number of visible columns.

So in my workbook the maximum number of columns that are visible is 63 (columns A:BK), all others are hidden. I am trying to have the workbook automatically set the print area to the following:

If visible columns are less or equal to than 33, format to:

• Landscape
• 1 page wide
• ([blank] pages tall)
• repeat columns A:B
• repeat rows 1-10

If visible columns are greater than 33, format to:

• Landscape
• 2 pages wide
• ([blank] pages tall)
• repeat columns A:B
• repeat rows 1-10

Is this possible?

[jaslake]

Hi maddog

Play with this

Please Login or Register  to view this content.