1. G

    Print hidden sheets -

    I used the following code to print a hidden sheet and my first sheet disappeared .......can anyone tell me what the problem was, please TIA GT Sub PrintOnlyHiddenWorksheets() Dim CurVis As Long Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets With sh...
  2. A

    Printing only rows with data?

    Hi all! I'm pretty sure this may have been answered before, but I'm self-taught in excel and know about 100% of nothing as far as coding goes, so I need to try an get this explained super simply if possible. The post I think I found before talked a lot about coding and something like VBA and I...
  3. A

    Select and Print Only Cells with Values

    Hi, newbie to VBA here. I have been researching and trying many ways to select and print a range, and I cannot find a way to print cells with values only. In my case, I create a list of entries through the day. I am creating a button so I can print all of these entries at the end of the day...
  4. L

    How to print every pages double sided in excel?

    Hi, For now, I go to print, select entire workbook, choose double sided, next page, rinse and repeat. The problem is I have 50 pages to do, is there a way to print the entire workbook double sided automatically? Thanks.
  5. K

    Programable Print Area?

    Is it possible to adjust the print area program-ably? I have a print area of say Cell A1 to Cell E50. This will do for 80% of my needs. Occasionally the table may extend another 15 rows or so. For this I would like to add a column F and use an "If" statement like If(E51 <>"", Set print area A1...
  6. H

    Macro to print and sort range

    Hello all not sure if what im needing is quite possible. Im needing a Macro to Sort a range and Print it without haveing to Sort the actual excel. Just need the Sorting to occur for print purposes not to effect the actual excel.
  7. C

    Multiple print job in one sheet

    Hi, Is there anyway to do a multiple print job in a single sheet quickly? For example, in this sheet call 'Shop Ticket', there are 100 pages. Sometimes, I need to print page 1-10, or 1-50 or 1-100. Sometimes, I need to print page 1-10 and 11-20 and 21-30 and 31-40 etc etc.... BUT all in...
  8. F

    Extract text from URL

    I have over 40,000 url similar to this one below What I want to do is create a listing title automatically from the above link so it reads: ANNE HATHAWAY A4 GLOSSY PHOTO PRINT #10 *FREE P&P* So basically I am taking the name and number...
  9. K

    Print area using table/range of cells

    I have a sheet with about 20 tables of data (one table per tenant), and I would like it to print as many of these tables as can fit on one sheet, but I don't want it to split any of the tables across two sheets. For example, if page 1 could feasibly fit 2.5 tables of data, I would want page 1 to...
  10. S

    Print selection code doesn

    Hello, I am trying to create a code to automatically select the range (that can vary horizontally) and print it. I tried to use this code, but it prints only 1 page regardless the amount of pages needed to print all data in range. And I don't even understand why it limits it to 1 page. Sub...
  11. L

    printing all workbooks names in one shot

    Hi The code below is to print each workbook's name. If I have 5 then it will msgbox these 5 files names. I want to improve this code so it can print all the name in one shot (not 5 msgboxs or whatever the number of the files). Is that possible? Thank you so much. Sub wb_names() 'to find...
  12. 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...
  13. willow1985

    VBA move print area down 1 row from active cell

    Hello, I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges? I currently have a macro that finds the end of a table and adds a row for new data however I would like to expand the print area after I add the row by 1 row. the only code I...
  14. I

    Specific print output - page with frozen panes

    Hello, I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows. I have set print titles according to instructions on this page. Afterthat I select range F3:AC10 and then print...
  15. T

    Print sheets

    Hi, I would like to print a table - 50 times - from excel, but on each printed sheet I would like the number 1, 2 ... 50 to appear. The table is in the range A1:G20. On the first printed sheet appear the number 1 (in D22) on the second sheet appear 2 and so on.
  16. V

    Print specific sheets seperately to printer and PDF

    Is this doable and could someone suggest a script? (Script would need to be seperate) 1. Print sheets seperately without prompt to the default printer: only if the sheet contains the text: "PrixMax" "6po" "Quote" (Then print them, else ignore) 2. Create a PDF per sheet (If sheet contains the...
  17. D

    Population of Multiple Templates from Workbook?

    Hi all, I'm hoping someone may be able to assist me with the following: 1. I have a table of data with filters applied from which I would like to fill (and print) templates in another worksheet as quickly as possible. In other words, each week I input some more rows into this table and then...
  18. S

    Printing code ignores some data/pages

    Hello, I have this simple code Sub Printout() Sheets("Breakdowns").Select Range("A1", Range("A1").End(xlDown).End(xlToRight)).Select Selection.Printout And I am not sure why this code doesn't work properly. It somehow misses middle rows, but prints all other from start to end.
  19. R

    Identifying Fillable Cell

    Does anyone have a good method of identifying cells that need to be modified in a spreadsheet to make it easy for the user to locate? I have not been able to find a way to highlight a cell or change the text color but not have them print in that manner, since I have color images on the form I...
  20. R

    Print All Text Black

    Is there a way to have all the text in a worksheet print in black, so that I can still have a color image print in color? I cannot choose the print black and white option in page setup because it turns the image black and white too. I am trying to figure out a way for users to easily identify...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...