Printing / Not Printing Ranges Based On Cell Contents
Apr 11, 2008
I have a report that is generated from a manufacturing process that looks like the example below. the report is 40 pages long when all the data is printed. i am looking for a way to only print this range if a dimension is "out of tolerance". if the dimension is within tolerance, there is always the "garbage" text of plus and minus. if every row is "within tolerance" in the range the cells in the OutTol column would all contain the "garbage" text but it will not always be identical. so, in summary, actual OutTol values = print and all "garbage" = not printed.
I would like to know if there is a way to print several different workbooks at once but keeping my printing format which I would like to be Landscape and Fit to one page. Reason is simple as I work in a office where staff is handed in several jobs to do everyday. They finish the jobs and log all the info on the database. I log on to database and put all their daily diaries and because it is all over the place I have to go in each file and set printing preferences which takes an hour in the morning and hour in the evening. I could do with some sort of automation where all diaries are automatically printed in Landscape and Fit on one page.
I am trying to print non continuous ranges of data in the same worksheet using the print area - by keeping the ctrl button pressed etc... it works fine but the outcome is that the text in the pages becomes very smaller when compared to when you print page by page and fit every page to one.
I am trying to write VBA code that will print a print range that is presented in cell F3 on a "Reports" worksheet. The content of F3 will change depending on how many reports the user selects to print. For example, he could select one, two, three reports etc - up to twelve. The cell ranges of each report are named (e.g. Report1, Report2 etc) so that if the user selects to print Reports 1 and 2, the contents of cell F3 are "Report1,Report2". If I replace WhatToPrint with "Report1,Report2" the print macro works.
Sub Macro2() Dim WhatToPrint As String WhatToPrint = Sheets("Reports").Cells(3, 6).Value 'sets the variable to equal the contents of cell D3 which contains the formula 'summarising the print ranges I want to print Sheets("Reports").Cells(3, 6).Select ActiveCell.FormulaR1C1 = WhatToPrint ' pastes the variable in cell F3 - just to check that it looks like I want it to Sheets("Reports").PageSetup.PrintArea = WhatToPrint 'uses the variable to set print area - this is where it fails! 'if you replace the variable with the contents of cell F3 the macro will work ActiveWindow.SelectedSheets.PrintPreview End Sub
I have a sheet that has a button on it that I would like to print a list based on a set criteria. My criteria is "if the value in Range D4:D100 is positive". I think a messagebox would be okay but although it is not needed yet, I would like to have the ability to print up to 100 rows on a single sheet of paper. The print should include Columns A:H of any row where respective D value is positive. If possible could Column D when used as a reference be made relative so that I can add or take away without losing functionality?
a way to select which ones to print based on the given condition. I have a store list, and on this list I provided the store number and their authorized vendors. I have a weekly spreadsheet that has all our vendors cost/retail changes. On this spreadsheet, the vendor numbers are on column A. I was hoping for something, like maybe provide the store number to print, and it will print only the vendors that that particular store carry... We have a total of 106 stores, so automating this process would definitely save us a lot of time.
I have a list of products that I want a message to appear prior to printing based on the description choosen.
Product descriptions are choosen in D25:D34 via a drop down.
My wild cards are SWING GATE and DOUBLE SWING GATE, I want to use wild cards because of the many different sizes of each gate.
Private Sub Workbook_BeforePrint(Cancel As Boolean) If Range("B" & Target.Row) = "swing gate" Or Range("B" & Target.Row) = "double swing gate" Then_ MsgBox (Range("F5").Value) & ", Please include chain and locks with order", vbOKOnly, "Chain and Locks" End If End Sub
I have several worksheets that have comments in the cells. Most of the comments i have set to "un-hide" and they can be printed. I now have this one spreadsheet where no matter what I do I cannot print the comments.
I must have something turned on or off but for thwe life of me I cannot figure out what it is. I can see the comments on the screen but when I go to print preview they are not there.
I am working on a form right now for a shipping company in MS Excel. Anyways, I have a few cells formatted as text that have a starting value of "[Insert Comments Here]". What I am trying to do is have it so that IF the cell has the original value "[Insert Comments Here]" upon printing, THEN the cell's value is changed to "" or some other way of not making it print.
I would like to be able to do this both with cells and the "Label" form objects.
I have a spreadsheet which is to be filled in by multiple users, in order to assist the users I have colour coded, and left unprotected, the cells that they need to interact with. I really don't want them messing with the formulae!
However, when a user chooses to print the sheet I would like the coloured cells to be printed in B&W.
I have a very little VBA knowledge - I know I need something to follow 'Private Sub Workbook_BeforePrint ()' or at least, I think I do!!
I've got an excel sheet that has a series of successive numbers down the side from 1-15 per sheet. I've done this by putting the cell formulas as previous row +1. (these are being used as unique reference numbers)
I want to be able to print this out multiple copies of this in one instance without having to manually adjust the first number multiple times then print the sheet. I also want it to be automatically saved as the most recent page printed, so that when it's printed the number continues on from the previously printed sheet.
I found a macro online which I have adjusted to increase a cell by 15 each time it is printed (to change the first number of the row). But I've realised that I'm printing the final page twice if I run the macro again. Is there any way to get round this? If I print 1 sheet there is also no adjustment in numbers.
I also haven't got onto the save part.
This is the macro I am currently using:
"Sub PrintSequence() ' ' PrintSequence Macro ' Macro recorded (altered) 8/16/2005 by Roy Wagner
I hold some data in the Excel 2007 file. It's about 400 rows and about 10 columns. On occasion I have to print some values from this file. But it has to be in defined position on the paper. It is like I already have the prepared paper with fields, and I just have to fill some fields on the paper with data from the columns. Is it possible to make a program that will take each row that I label for printing, and print just some columns but in a defined position on the paper ?
I am automating a paper form that collects information from 7 other paper forms and then prints out the results. I have created an excel spreadsheet to do this but I am having problems getting the printed output to match the print preview.
I have inserted an image of the form into the sheet header and aligned the cells on the sheet so that the information is in the correct position when previewed in "print preview".
The problem is that, although this will print correctly on the machine I created it on, it is misaligned on any other machine I have tried.
I have inserted checkboxes in an excel worksheet to turn on/off certain data. They are working just fine. But I have set them all to not print (by unselecting the checkbox that says "print" in the format dialogue). SOME of the checkboxes don't print, but most of them do. I can't figure out why.