Hello:

I need a Vb macro to do print setup.

I have lots of daily data from column A thru column J.

Each day data range upto 45 rows.
So basically
1st day data will have range A1:J445
2nd Day data will have range A46:J90
3rd Day data will have range A91:J135

and so on until day 31st.

Need a macro so to configure Page setup so that each day data is printed on one page.

Let me know if you have any questions.
Thanks.


Riz