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

• 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.

REFERENCES

"Function Reference," version 3.0, pages 201-202 "Function Reference," version 4.0, pages 365-366