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,prin t_what,color,feed,quality,y_resolution,selection,p rinter_text,print_to_file,collate)


"aftamath77" wrote in message
...
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.

"Bob Umlas" wrote:

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,prin t_what,color,feed,quality,y_resolution,selection,p rinter_text,print_to_file,collate)


"aftamath77" wrote in message
...
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.

"aftamath77" wrote:



"Bob Umlas" wrote:

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,prin t_what,color,feed,quality,y_resolution,selection,p rinter_text,print_to_file,collate)


"aftamath77" wrote in message
...
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.