Can this be done

[mahmed1]

Hi All,

I have set multiple Print areas

i.e

A1:A26,D1:D26,G1:G26,M1:03

Is there a way i can print them all in one page so it looks like its joined and that's how it looks on the spreadsheet?

Thanks

 

[ClimoC]

No.

The closest you could get, would be to code something that copies all these ranges to a separate sheet, and then print all rows/columns of that sheet on one page

 

[mahmed1]

Is there any chance you can help me withthis Code

 

[sdruley]

One thought would be to create a new worksheet and copy the respective ranges in the original worksheet into the new worksheet where you think it will look best. When pasting use past link and the new worksheet will always be up to date. Now all you have to do is to print the new worksheet. No code is needed.

 

[ClimoC]

Stephen's idea works just as well. Better probably.

PS Stephen... Looks really bad when you quote yourself...

 

[Eric Golf]

Hi,

Or you could hide the other columns.

Eric

 

[Armando Montes]

This might help:
Multiple Print Areas on a Single Printed Page (Microsoft Excel)

 

[sdruley]

ClimoC,

If I had written a book on the two new areas of mathematics that I have invented or the new frontiers that I have forged in business science then it might be appropriate to consider the book as a way of quoting myself. And, at 70 years of age one begins to harbor a great deal of wisdom about life and possesses a certain degree of earned respect. But I can see how quoting yourself in the context of this forum could be interpreted as egotistical so I am removing most of my signature, which was originally intended to help others.

 

[ClimoC]

ClimoC,

If I had written a book on the two new areas of mathematics that I have invented or the new frontiers that I have forged in business science then it might be appropriate to consider the book as a way of quoting myself. And, at 70 years of age one begins to harbor a great deal of wisdom about life and possesses a certain degree of earned respect. But I can see how quoting yourself in the context of this forum could be interpreted as egotistical so I am removing most of my signature, which was originally intended to help others.

At the risk of going WAY off topic, I do apologise for any offence caused. Perhaps it's just the waiver from the norm... the Wildes, the Hemmingways, the Washingtons, etc...

In any case your solution would work...