printing

  1. P

    Printing workbook to PDF

    Hello, How do I print my workbook to PDF. I am close but not there yet. Instead of posting my non working code I was hoping someone could put some code on here. I am going to assign the macro to a button. I would like to put the folder path in one cell U18 the filename will be in three...
  2. argeedblu

    Hidden Rows Printing

    A client of mine has a workbook in Excel 2007 (although it may be descended from an earlier version of Excel.) When she prints the workbook, hidden rows are printing along with rows that are not hidden. The rows in question do not appear in Print Preview but they do appear on the hard copy. Any...
  3. srikanth58

    Printing news letter to different addresses

    Hi all, I dont know whether I have put the right title to this question. But any way... I have a news letter, you can say monthly account, in a table A1:F25. A2 has employee name, C2 has Employee number and D2 has his schedule group. Columns H, I and J have list of Employee name, number and...
  4. J

    Multi-Column Combo Box Not displaying selected entry when Printed

    I have a work sheet with a combo box. The ListFillRange is a 2 column array. In column 1 is a list of Report Names. Column 2 contains the data source for the Report. In the Properties for my ComboBox, I have Bound column set to 2 and Column Count set to 1, as I need the data source put into...
  5. R

    Database - printing 2 columns to a page

    I have a database of 1000 names + addresses ( each record has 4 columns) . I want to print 2 x 4 columns of details to a page - in alphabetical order. I can get 60 lines to a printed page. So on page 1 there would be records 1-60 on the left of the page and records 61 to 120 on the right. Next...
  6. T

    Printing from a Listview in Visual Basic 2008

    Hi, I am trying to print the items which I have entered into a Listview box. At the moment all the data entered appears in the text box and all the calculations are completed successfully. However when i try to print the data in the listview it comes up with the title and the date just as I want...
  7. G

    Macro help needed plx

    Hi guys, Trying to figure out how I can insert a button that will print sheet 1 on an A4 sheet from tray 1 of the printer, and then print sheet 2 on an A5 sheet from tray 2 of the printer. I figured that a macro would be able to do this, but I am unsure of how to create such a beast. Any help...
  8. R

    Print dialog seems to resize a text box - ?

    I have a (semi-inherited) macro that prints different pages of a workbook, based on whether and what their entries are. One of the pages contains a text box, where users will enter different lengths of text. When the macro runs, it prints right the first time but also "resizes" the text box so...
  9. R

    Dynamic Print Range

    Hi, I have seen some posts regarding dynamic print ranges, but I have not been able to find quite what I need. So here it goes: Problem Description: I have an application where I allow a user to select from a list of "reports" on a form. Each report is on the same worksheet, so say 5 reports...
  10. H

    Excel Macros are driving me mad

    :mad: I have a spreadsheet that will be of variable amount of rows but with fixed headers i.e. address address header header header data data data data data data data data data What I want to be able to do is print the different rows of data on seperate pages with the...
  11. T

    Wrap Columns for Printing - Excel 2003

    Hello spreadsheet gurus. Using Excel '03, is there a print or other setting that will automatically "print-wrap" four columns into eight, so that I reduce my printed page count? I have four rather narrow columns of information that when printed print across eight pages. This wastes paper...
  12. W

    Printing Worksheets based on name only

    Hi everyone, I'm trying to figure this out. I need to print a workbook out (about 60 sheets 10 to 15 which shouldn't be printed out) based on whether the sheet contains the name _exhibit. I have a hunch that the workbook should contain an If statement and an array but I'm not sure how to code...
  13. A

    Problems printing to a network printer

    I have written a macro to print to a specific printer on the network. I started by using the macro recorder to see what Excel liked for the printer name, and then added code as necessary. It is a very simple macro that defines a print range, then prints to the specified printer as follows...
  14. M

    print counter (macro)

    dear friends I need a macro to count how many time spread sheet is printed! it doesn't seem very difficult!but I can't!please help!;)
  15. C

    Printing Graphs in pfd

    I have a Excel workbook to produce and print a lot of graphs (Excel 2003). The workbook uses a Graph template and changing the data in the template allow to print all the graphs. This is done with a Macro. When trying to print using the printer option "Adobe pdf" to produce graphs in pdf...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top