XL: PRINT?() Macro Function Ignores From and To Arguments

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
• Microsoft Excel for OS/2, versions 2.2, 3.0
• Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0

SYMPTOMS

In the versions of Microsoft Excel listed above, the PRINT?() macro function ignores the from and to arguments (the arguments that specify which pages to print). As a result, when you run a macro that contains this function, all of the pages in the worksheet will be printed.

For example, if you enter the following function

   =PRINT?(2,2,2,,,true)

NOTE: In the Print dialog box, 2 is entered in From and To boxes; however, the All button remains checked.

WORKAROUND

To work around this problem, use the PRINT() function instead of the PRINT?() function. This will allow you to print only the pages you specify in the from and to arguments.

To print only page 2, use the PRINT() function (without the question mark):

   =PRINT(2,2,2,,,true)

MORE INFORMATION

The syntax for the PRINT?() macro function is as follows:

  =PRINT?(range_num,from,to,copies,draft,preview,print_what,color,feed,
   quality,v_quality)

• To print all pages, type "1" (without the quotation marks) for this argument.

      -and-
  

• To print a specified range, type "2" (without the quotation marks) for this argument.