Print setting in a sheet for specifc area.

17 views
Skip to first unread message

Heerapanna Chavan

unread,
Jan 29, 2019, 12:01:40 PM1/29/19
to excel vba
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

Suresh Kumar B

unread,
Aug 27, 2019, 3:18:14 AM8/27/19
to excel vba

Hi Chavan,

Please use the attached file, It may helpful to you.

Thanks,
Suresh

Noong Martes, Enero 29, 2019 ng 10:31:40 PM UTC+5:30, si Heerapanna Chavan ay sumulat:
Solution.xlsm
Reply all
Reply to author
Forward
0 new messages