print array

  1. S

    Selecting sheets based on value in cell

    Hi, I have a workbook where I want to print selected sheets, based on worksheets named in a cell i Excel. In cell A1 in Worksheet1 I have the names of the sheets I want to select, seperated by comma. The value in cell A1 is "Report1,Report2,Report3" and so on, and it changes based on inputs in...
  2. T

    Print any Hyperlink files to PDF - VBA

    Hello! Can someone help me: I would like to print excel file I have as a hyperlink with the name in the file path. also if it is possible to print on a certain paper size, orientation, pagefit and saved in the path B1 <colgroup><col><col span="2"><col></colgroup><tbody> Filepath...
    • thpwn
    • Thread
    • .xls cusersxxxxdesktopyyyy hyperlink pdf print array
    • Replies: 8
    • Forum: Excel Questions
  3. S

    Printing an Array of xlsx worksheets from a separate xlsm file

    I'm trying to figure out code that will print out specific worksheets from an xlsx file from an xlsm file. Let's say the file I want to print sheets off of is Print.xlsx and I want to print tabs Sheet1 and Sheet2. I created an xlsm file and have this code: Sub PrintPages() Dim wb As Workbook...
  4. W

    Cmnd Bttn to show print dialog box and print hidden sheet

    I have a workbook that contains 1 visible sheet and 3 hidden sheets. Each hidden sheet has a form associated with it that inputs data to cells on it's associated sheet. I also have a print(command) button on each form. The sheet needs to be printed twice; one to a PDF file, and one to a printer...
  5. A

    Select only visible sheets from an array for printing

    Long time lurker, first time poster :) I need help figuring out how to select the visible sheets from an array so that they may be printed while excluding all other sheets, visible or not. At all times I have at least 1 ws out of an array of 11 visible. I have 2 other ws that are always...
    • ashline02
    • Thread
    • array print array print visible print visible sheets select visible sheets
    • Replies: 5
    • 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