I used the following code to print a hidden sheet and my first sheet disappeared .......can anyone tell me what the problem was, please
Dim CurVis As Long
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
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...
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...
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?
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...
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.
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...
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...
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...
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.
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.
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
Application.EnableEvents = False
If Len(Target.Value) = 7 Then...
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...
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...
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.
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...
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...
I have this simple code
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.
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...
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...