Microsoft KB Archive/104579
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
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.
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.
- If you must apply borders to the entire column and/or row, specify the entire worksheet for the reference argument. For example, use
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.
- Use the BORDER() function in your macro to replace the borders on the worksheet after you've applied the best-fit formatting.
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.
"Function Reference," version 3.0, pages 201-202
"Function Reference," version 4.0, pages 365-366
Additional query words: deleted clear M_eXceL XL3 XL4
Version : WINDOWS:3.0,4.0,4.0a; OS/2:3.0; MACINTOSH:3.0,4.0
Platform : MACINTOSH OS/2 WINDOWS
Issue type :
Last Reviewed: April 7, 1999