I have imported a worksheet from Lotus to Excel2002, which is the version we
are using at work still.

My problem is part of the worksheet, needs to be printed out in portrait and
another section of the same worksheet needs to be printed out in Landscape.
Now I have searched for a similiar question here on
Excel.Worksheet.Functions, and couldn't find any results. Have also checked
on Ron' Excel page, and I even Google for a answer, but alas, nothing
explains how to do what I want it to do.

I even tried playing with report manager, but that didn't work either. I
also should say, that I have given a name to the section that is to be
printed out in portrait, and another name to the section that is to be
printed out in landscape.

Any help would be appreciated.

Steve