Microsoft KB Archive/101338

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