Excel: Using LINE.PRINT to Print Multiple Lines on a Page

• Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

SUMMARY

Normally the LINE.PRINT() function performs a form feed operation after it has printed. As a result, only one LINE.PRINT() job prints on a page. This article explains how to use the LINE.PRINT() function to print one or more lines of text to a single page.

MORE INFORMATION

The LINE.PRINT() macro function prints the active document using methods compatible with those of Lotus 1-2-3.

NOTE: LINE.PRINT() does not use the Microsoft Windows printer drivers.

Example

The following macro example sends a line of text to a printed log whenever the current time is past 10:00 A.M. (it does not perform a form feed operation after the print job, and therefore prints each line on the same page):

   A1:     Print_Macro
   A2:     =IF(NOW()>=TIME(10,0,0))
   A3:        =LINE.PRINT(5,,,,0,0,2,FALSE)
   A4:        =LINE.PRINT(1)
   A5:     =END.IF()
   A6:     =RETURN()

• LINE.PRINT(LINE.PRINT(command,setup_text,leftmarg,rightmarg, topmarg,botmarg,pglen,formatted)
• The command argument 5, in cell A3, tells Microsoft Excel to set up the page formats. The remaining arguments format the page without top or bottom margins, a page length of two lines (allowing for a blank line between each printed line), and no headers or footers.
• The command argument 1, in cell A4, tells Microsoft Excel to print the currently defined print area on the active worksheet.

REFERENCES

"Online Help," version 5.0 "Function Reference," version 4.0, pages 253-254