VBA to AutoSet Print Area.

[Phamaily]

Hi All,

I need help on a VBA Code, since i'm not really that good with VBA.

What I created is an excel workbook driven by to input cells, where the rest of the report would auto populate and auto expand.

By doing so, my auto set printable would not set right.

I would like the report to include all rows between 4 thru 46,

and the columns to include "Aggregate Totals" which will be the last column.

Can Anyone help me?

[jaslake]

Hi Phamaily

Probably something like this

Please Login or Register  to view this content.

[Phamaily]

Thank You John,

May I ask,

is there a code to mark this "ON Change" on C1?

[jaslake]

Hi Phamaily

I don't understand the question...please explain

is there a code to mark this "ON Change" on C1?

[Phamaily]

John,

I mean, is there a code, that I can add to this macro setting..

where if there is any change on cell "C1", then run this macro.

[jaslake]

Hi Phamaily

I can't see your File so I have no clue what a change in Cell C1 has on setting the print area. Post your file so I can see...explain what it is you wish to do...