XL97: Print Area with Merged Cells May Be Set Incorrectly (170683)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q170683 SYMPTOMS
When you set a print area on a worksheet in Microsoft Excel 97, the print
area may not be set correctly if the worksheet contains any merged cells.
Specifically, only part of a merged cell may be included in the print area.
As a result, when you print the worksheet, the output may not contain all
of the information.
CAUSE
This problem may occur if you use either of the following methods to set
the print area:
WORKAROUND
To prevent this problem from occurring, use any of the following methods to
set a print area:
- Instead of typing print_area in the Name
box, point to Print Area on the File menu, and click Set Print Area.
-or-
- If you are using a macro to set the print area, modify the code so
that it uses the Selection property instead of the Range property. For
example, if your code currently looks like this
ActiveSheet.PageSetup.PrintArea = Range("B2").Address
change it to the following:
Range("B2").Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
-or-
- Make sure that the range referred to by the macro includes all of
the cells that have been merged, for example:
ActiveSheet.PageSetup.PrintArea = Range("B2:F20").Address
Using any of these methods ensures that the print area is set correctly.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/7/2001 |
---|
Keywords: | kbprb kbprint KB170683 |
---|
|