Microsoft Knowledge Base
Excel: Second Argument in SET.PRINT.TITLES Must Contain Colon
Last reviewed: September 12, 1996
Article ID: Q101338
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a
- Microsoft Excel for the Macintosh, version 4.0
Page 392 of the "Function Reference," version 4.0, gives the following example for the SET.PRINT.TITLES() macro function:
SET.PRINT.TITLES("",$B$B)
This information is incorrect. The second argument the example should be expressed with a colon separating the B and the dollar sign ($B:$B). The following example shows the correct syntax for this function:
SET.PRINT.TITLES("",$B:$B)
The macro formula above specifies column B as the source for row titles and omits column titles.
REFERENCES
"User's Guide 1," version 4.0, page 255
KBCategory: kbdocerr Last reviewed: September 12, 1996 |