[RESOLVED] Setting Print Ranges In Excel

I have just been asked to find out if it is possible to set more than one print range within the same Excel spreadsheet.

I have no idea.

Can you?

If so, how?

PS: Not through code, but from within Excel itself.

Yes it is possible. Within the "Page Setup" dialog, on the "Sheet" tab, you can enter multiple ranges seperated by commas. Each range will begin printing on a seperate page.
Eg

Code:

---

A6:C19,F7:L19

---

Quote:

---

Originally Posted by DKenny

Yes it is possible. Within the "Page Setup" dialog, on the "Sheet" tab, you can enter multiple ranges seperated by commas. Each range will begin printing on a seperate page.
Eg

Code:

---

A6:C19,F7:L19

---

---

You have just made a manager very happy (and as this is the manager that signs my timesheet every week, I'm pretty darned tickled as well! :D ) She didn't think it was possible, but asked me if I could verify this for her.

Now, if you could only make my manager happy..... :(