activeworkbook.printout

  1. A

    Auto Print after scanning in 7 digit barcode

    Hey guys, I am wanting to print a label automatically after user scans in barcode in A1. The code I am using is If Intersect(Target, Sheets("Sheet2").Range("A1")) Is Nothing Then Exit Sub Else Application.EnableEvents = False If Len(Target.Value) = 7 Then...
  2. P

    Macro to change cell value and print to PDF

    Hello All I need help with this macro please Sub Macro4() ' ' Macro4 Macro ' ' Range("Q2:X2").Select ActiveCell.FormulaR1C1 = "4" Range("Q3:X3").Select ActiveWorkbook.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False Range("Q2:X2").Select ActiveCell.FormulaR1C1...
    • playerdee2
    • Thread
    • activeworkbook.printout ignoreprintareas=false macro macro4 rangeq2x2.select
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top