print

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.

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...

I have over 40,000 url similar to this one below https://i.postimg.cc/4xRS70r0/Anne-Hathaway-10.jpg 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. Sub...

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...

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...

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...

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. https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html Afterthat I select range F3:AC10 and then print...

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.

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...

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...

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.

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...

I have an Excel template (wb1) containing VBA to print the set range of a sheet in another workbook (wb2) via a command button. Depending on the options chosen in wb1 will depend on which sheet w/in wb2 prints. The code works, but wk2 contains many sheets (each having their own print area set...

Good Afternoon Mates! I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved. Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...

Hello all, can you help please, I have inherited a workbook to look after, it has a sheet called “TIMESHEET” and one called” FINGER PRINT LOOKUP” first on has the following columns, date, user id, and finger print hours worked. last sheet records user id, in, out, and total time. (there are...

I have a workbook where I allow the user to print certain sheets. (There are potentially 30 to choose from, and they can print as few or as many as they want.) They have the option of having the date & time appear on each sheet, in the right footer. The code places this info in the right...