Set print area

[Gmil]

Hi,

I have the following code to set the print areas of all worksheets, but it is now coming up with an error.
Any suggestions?

Please Login or Register  to view this content.

[jolivanes]

For what it is worth, it works for me with Excel 2007.

[Gmil]

I have moved a number of sheets to a different workbook and adding sheets. Would this cause a problem. If so, could I copy the workbook into a new workbook to solve the problem?

[jolivanes]

Did you try it on another workbook?
If not, just make a temporary workbook with all the cells in your range filled with something.

[jolivanes]

Does this make a difference?

Please Login or Register  to view this content.