Microsoft KB Archive/104579

{|
 * width="100%"|

XL3/XL4: Function with Best Fit Removes Borders from Worksheet

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
 * Microsoft Excel for OS/2, version 3.0
 * Microsoft Excel for the Macintosh, versions 3.0, 3.0a, 4.0

-

SYMPTOMS
In Microsoft Excel, if you use the ROW.HEIGHT macro function to format a range of cells with a best-fit height, borders may be removed from your worksheet.

This problem occurs most frequently when borders have been applied to the entire row or column.

WORKAROUND
To work around this problem, do one of the following:


 * Apply borders to a range of cells rather than to the entire column or row.

-or-
 * If you must apply borders to the entire column and/or row, specify the entire worksheet for the reference argument. For example, use

=ROW.HEIGHT(,"R1:R16384",,3)

to change all the rows on the worksheet to a best-fit row height.

Note that when you use this workaround borders may still be removed from the first row of the worksheet.

-or-
 * Use the BORDER function in your macro to replace the borders on the worksheet after you've applied the best-fit formatting.

STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel versions 3.0, 4.0 and 4.0a for Windows, and Microsoft Excel versions 3.0 and 4.0 for the Macintosh. We are researching this problem and will post new information here as it becomes available.