Print Using VBA

[longytravel]

Afternoon,

I have a sheet that is populated by a userform.

All works great thanks to some help from you guys. The data runs from Column B : I (starting at B2)

I have a bit of VBA that sizes the columns so they look perfect on the screen

I would now like to produce something that prints it in the most 'visually friendly way'

Each row of detail could potentially have quite a lot of detail, there could be up to 20 rows at any one time so it will spill onto more than one sheet - maybe quite a few sheets

What code would be suitable to keep it easy to read and not waste loads of paper.

All the formatting on screen is fine

I guess as a minimum i wouldnt want to split any rows over two sheets i.e if a row is at the bottom of the page and would spill onto the next sheet the code jsut starts the row on the next sheet from the start - can that be done??

Thanks as ever!

 

[bensonsearch]

Afternoon,

I have a sheet that is populated by a userform.

All works great thanks to some help from you guys. The data runs from Column B : I (starting at B2)

I have a bit of VBA that sizes the columns so they look perfect on the screen

I would now like to produce something that prints it in the most 'visually friendly way'

Each row of detail could potentially have quite a lot of detail, there could be up to 20 rows at any one time so it will spill onto more than one sheet - maybe quite a few sheets

What code would be suitable to keep it easy to read and not waste loads of paper.

All the formatting on screen is fine

I guess as a minimum i wouldnt want to split any rows over two sheets i.e if a row is at the bottom of the page and would spill onto the next sheet the code jsut starts the row on the next sheet from the start - can that be done??

Thanks as ever!

I always like the range way.

range("B2:I20").printout

but you can do the same for an active sheet (only problem is its the whole sheet where the above is what ever you want)