Print Setting in a sheet for specifc area.
 

Hi All,

I have a range of area, lets say from "A1:H1000" and I want to print this area in 20 pages.

I want to print 50 rows in each pages. I am unable to find a code on net please help.

Regards
Heera Chavan

Print Setting in a sheet for specifc area.
 

On Thursday, 31 January 2019 00:59:56 UTC+13, Heera wrote:
Hi All,

I have a range of area, lets say from "A1:H1000" and I want to print this area in 20 pages.

I want to print 50 rows in each pages. I am unable to find a code on net please help.

Regards
Heera Chavan


Heera. You do not need a code.

You can set up the pages by selectiong your area.

Set print area. A1 to H1000.
Select number of pages long... 20
Select number of pages wide... 1
Select print preview.

Regards Bill Kuunders