Set print area as multiple ranges

**TPDave** · 05-19-2014, 06:54 AM

Hi All,

I've uploaded a sample sheet which will hopefully be easier. I need my print area to be rows A2:H2 (headers) and all the rows (from A to H) which have an entry in column M but not in column P. So for the attached example I would need the print area set for the following:

A2:H2
A18:H22
A26:H29
A32:H34

I've tried doing a range with multiple arguments but it breaks once I move away from set limits and make them variables so am very confused!

Any help would be greatly appreciated. Thanks

**TPDave** · 05-19-2014, 10:10 AM

Now that it's a bit later in the day hopefully some of our American friends could look at this?

Many thanks!

**jaslake** · 05-19-2014, 10:42 AM

Hi TPDave

Do you wish the Code to be attached to the Print Button in the User Form?

**TPDave** · 05-19-2014, 10:45 AM

Yes please!

**jaslake** · 05-19-2014, 10:56 AM

Hi TPDave

If I understand your issue, this Code appears to do as you require...set the indicated Parameters...

Please Login or Register  to view this content.

**TPDave** · 05-19-2014, 11:13 AM

That works great thanks!

**jaslake** · 05-19-2014, 11:39 AM

You're welcome...glad I could help. Thanks for the Rep.

Set print area as multiple ranges

LinkBack

Thread Tools

Rate This Thread

Display

Set print area as multiple ranges

Re: Set print area as multiple ranges

Re: Set print area as multiple ranges

Re: Set print area as multiple ranges

Re: Set print area as multiple ranges

Re: Set print area as multiple ranges

Re: Set print area as multiple ranges

Thread Information

Users Browsing this Thread

Similar Threads

Code and Formula to print dynamic print area ranges

Set Print Area for changing ranges on a sheet

How to set fixed print area in excel so cells within print area can still be modified?

[SOLVED] Using names ranges to set print area in a macro

[SOLVED] set the print area print multiple tabs

Bookmarks

Bookmarks

Posting Permissions