printer selection

  1. B

    Printing to multiple printers

    Hi, I need some help writing a macro for printing. My excel file for generating a Purchase Order is like this: Sheet 1: User fills in all the data. Also has a command button for print. Sheet 2: (Hidden) Takes data from sheet 1 and formatted for printing (zoom, print areas, margins etc are...
  2. V

    Using VBA code to set printer with variable name

    I have code that searches for the correct network node for the selected printers. The problem is that I have a variable getting set with the address to be passed back to be used as the printer. Need help. I had this code working and then all of a sudden the code stopped working. Sub...
  3. P

    Concatenate printareas

    To the Excel/Printing expert, I made a macro for printing the 12 sheets (named 'jan', 'feb'...etc). Besides some user questions the macro has 12 times the following statement: (generated via the 'recording macro' function) Sheets("jan").Select ActiveWindow.SelectedSheets.PrintOut...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top