1. R

    Prints Sheets and SaveAS Macro

    I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?
  2. A

    Sheet prints twice

    Good Day, I have button when clicked it prints a range of rows on a template. Application.Dialogs(xlDialogPrint).Show RowCount = Range("B2") Worksheets("Payslips").Select For i = 1 To RowCount Step 5 Range("B4").Value = i ActiveSheet.PrintOut...
  3. N

    Print Visible Cells after Filtering

    When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...
  4. D

    VBA Excel Series Of Prints

    Good afternoon I have a a VBA (EXCEL) which looks across columns and rows then prints a series of sheets accordingly what happens is a preview window pops up I still need the selection of a printer but would like then to print with no interference
  5. N

    Graph not displaying the same in print preview

    Good morning, hopefully this is an easy fix. I have a graph that displays the axis on the screen slanted but when I print it, it prints straight. I have another graph on the same page that prints and displays slanted correctly. Anybody has any ideas on how to fix this? Thank you!
  6. F

    Formula needed for volume discount pricing

    Hi everyone, I own a printing business and there are a TON of variables in print pricing lol. So I need a formula for multi-page booklets (like catalogs) Basically I will put a formula in that will come up with the number of prints it will take to make a multi-page booklet and I need the...
  7. M

    VBA print with predefined workbook name in PDFCreator

    Hello, I am working on solution that will help to manage huge amount of prints. Those prints are triggered with macro loop depends on number of data. So when there is 100 prints, all prints are displayed in PDFCreator as current workbook name title. What I want to accomplish is to change or...
  8. M

    Loop through slicer in pivotable prints too many pages

    I found a vba code that I copied on this forum that lopps through a slicer and selects / deselects each name and bring up the relevant data for that person and prints it. It works but for some reason it keeps creating prints about 104 pages when there are only 39 names in the slicer. The last...
  9. S

    Cancel button not canceling

    Hi all, Because I need to print on other printer than default, I use VBA code to show all available printers, then select needed printer & print: Sub Show_PrintersDialog_and_Print_Cards() Application.Dialogs(xlDialogPrinterSetup).Show Call Print_Cards End Sub The problem is this...
  10. T

    VBA Print Conditioning

    Hi folks, I'm currently working on a user form which populates a worksheet and then prints, I am trying to add a question to the user form in which the user must answer correctly for the sheet to print. This is my current code which does not work Private Sub CommandButton1_Click() 'populates...
  11. W

    Printing Issue

    I have a worksheet where one macro creates a new worksheet from a pivot table and prints a copy for an employee's record. That print is in color and portrait even though the code says to print b&w and landscape. While also creating a new worksheet the code creates a button on the new worksheet...
  12. W

    count the prints

    how can we count the number of prints taken for a sheet in a cell.
  13. S

    Excel VBA with Counter

    Im trying to create a VBA that reads in a certain cell value (any number from 1 to 10 depending on the input from the user) and then changes to value to read "1 of 10" and prints out a sheet. Then the value increases to read "2 of 10" and prints out again, this needs to continue until all the...
  14. P

    Need help writing a VBA function that prints a loop

    Hi everyone, I am messing around with Excel and as an assignment I need to create a VBA function that prints my name 10 times in a loop. Then I need to create a button that will trigger the function. How can I do this? I tried: Module Hello Sub Main() MsgBox ("Hi, my name is Pat") End...
  15. M

    save and print tabs

    Hi I have the following code that saves and prints just the visible tabs in a workbook, but I want to change the code so that it only saves and prints the first two tabs only could do with a little help if possible :) Sub SaveShts() Dim Ws As Worksheet Application.ScreenUpdating =...
  16. U

    VBA sets print margins for 9 pages, but they don't print in the right order

    Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following: <code> ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221" </code>...
  17. P

    Macro to change cell value and print to PDF

    Hi all Right, I need a macro that changes a cell in my sheet then prints all active sheets via PDF. Sounds really short and simple but I'm getting nowhere quickly. My spreadsheet contains a lots of hidden pages which I don't need prints hence just active sheets plus the list of cell changes...

Some videos you may like

This Week's Hot Topics