Set Print Area with dynmic range in rows

Please Login or Register  to view this content.

Thank you so much

You're welcome

Originally Posted by jolivanes

Please Login or Register  to view this content.

Sir, One last help needed. In the same code i wants to add a new print area i.e. range $N$1:$S$18. I wants to print this range $N$1:$S$18 in the separate page after the print of my earlier range "A1:M" & Cells(Rows.Count, 1).End(xlUp).Row).Address ends.

Please help if it is possible. Thanks.

- Abhinav

There is all kind of ways of doing that. One way would be

Please Login or Register  to view this content.

You can extend the Array as much as you like/need.

Thank you Jolivanes. That worked for me.