need a macro to print 2 page of a worksheet onto 1 a4 page

[echobase77]

help. I am trying to shrink down a worksheet so instead of printing at 100% size to fit on one A4 page I want it to print 2 pages onto 1 A4 page.

I can do it manually > page setup>options> 2 pages per sheet but when I record the macro it will not replicate what I have just done.

There must be a way to do it

[Alf]

Not tested but perhaps something like this?

Please Login or Register  to view this content.

Alf

[echobase77]

no that not right.
I should probably be clearer. I have a worksheet that could be as long as 100 pages if printed at 100% on A4. I want to be able to condense these so I get 2 pages from 1 A4 page. I.e print 100 pages but only using 50 sheets in the printer

[Alf]

I should probably be clearer.

Well it certainly makes it easier to find the right answer to you problem. So what you need I think is a macro that first determins the number of "used" rows in the worksheet and then splites the range up in a number of blocks to print.

Example your worksheet contains 300 rows with data starting at row 1. If a "normal" print out is 25 rows par example then your data should be split into 6 blocks each containing 50 rows for "condensed" print out. Right?

I also assume that you do wish to print your data as portrait and do your data fit the A4 formate? I.e. if the number of columns is to big a "normal" print out of 25 rows will then generat 2 pages. So do the macro need to check number of columns as well?

Alf

[echobase77]

yes thats sounds right