Print Code

  • Thread starter Thread starter aftamath77
  • Start date Start date
A

aftamath77

I was checking on an excel workbook that was forwarded to me, and I saw this
code for a macro tied to a userform within a worksheet. I didn't know what
the userform was for.

ActiveWindow.SmallScroll Down:=-51
Range("A84:H143").Select
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)"

I don't recognize the syntax for the print command. I do see that there
must be a bunch of default values selected.

Could someone please explain what the final line means and explain the syntax.
 
If you right-click the sheet tab, select Insert, then choose MS Excel 4
Macro, then type in a cell
=Print
and while the cell is still active, press ctrl/shift/A and you'll see:

=print(range_num,from,to,copies,draft,preview,print_what,color,feed,quality,y_resolution,selection,printer_text,print_to_file,collate)
 
Bob Umlas said:
If you right-click the sheet tab, select Insert, then choose MS Excel 4
Macro, then type in a cell
=Print
and while the cell is still active, press ctrl/shift/A and you'll see:

=print(range_num,from,to,copies,draft,preview,print_what,color,feed,quality,y_resolution,selection,printer_text,print_to_file,collate)
Click to expand...
 
Back
Top