printout

Hello, I am trying to reference a cell containing text information in cell "D5" on sheet "Company Lists" as apart of the PrToFileName parameter fir .PrintOut. The code works when manually replacing the "name" variable with the text inside quotation marks (ex. "AAPL"). Please see my code below...

I found in this forum how to printout sheets with different values, but I'd like to print all the sheets in a single PDF Document. How can I fix this VBA code to do this? Sub PrintAll() Dim i As Long, LastRow As Long LastRow = Worksheets("Names").Range("A65536").End(xlUp).Row For i = 1 To...

Hello, i am trying to run a macro that print an array of sheets in the description. However i have a macro that hides certain sheets pending other options and when i do the printout option it comes up with an error if one of the ****s has been hidden. The sheets need to remain hidden depending...

Hi all, kinda new to VBA, but im currently working on a userform. (Enligsh not my native language) I have a userform that allows me to print out a userform, but i want to get multipel pages. This is the current code i have, the printer is my defualt. But i cant get it to work when i change...

Hi All, Is it possible, to have printout in Excel with NO margins (maybe with macro) ? Thank you in advance.

Hello, I use this line in my code to printout copies of sheet3, I need it to print 2 copies, not just 1? any help would be greatly appreciated. I am sure it is very easy change to this line, but I cant get it to work. Sheet3.Range("A1:I20").PrintOut Next Next End With

How do I print a sheet and have the tab show up in the document?

I've been trying to create an UserForm for printing from a dinamically generated ListBox of available Sheets on my workbook. It looks like this: I set 1 - fmMultiSelectMulti in the ListBox properties to allow multiselection. Usually, I need the sheets printed in color, as well as a copy...

Dear all, I've been trying to create an UserForm for printing from a dinamically generated ListBox of available Sheets on my workbook. It looks like this: I set 1 - fmMultiSelectMulti in the ListBox properties to allow multiselection. Usually, I need the sheets printed in color, as well as a...

Dear All, Please find below mentioned VBA code.I tried to take printout of the employees name in certificate.Name are mentioned in workers sheet and certificate format is in Worker_Certificate sheet. Private Sub CommandButton1_Click() x = 2 Sheets("Workers").Range("B" & x).Copy...

Hi Guys! Is there a way to have a certain cell that is inside a print range to not print? For example... my print range is A1 thru F10. But I have data in cell C5 and that should never be shown on the printout. Is there any way to make that one cell always be non printable? Thanks in...

Hi,I have used below code to fill certain OLEObjects in a loop:Dim rng As RangeDim wsS As WorksheetDim wsD As WorksheetActiveSheet.Copy after:=Sheets(Sheets.Count)Sheets(Sheets.Count).Name = "Sourcebook"Set wsS = Sheets("Sourcebook")Set wsD = Sheets("CMR")Set rng = wsS.Range("A3"...

I want to print 3 copies but what do I enter for the From and To varients? expression .PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas)

This is my first thread over here, I hope I'll have some luck with it :) I have a sheet, with 132 pages (all with page breaks). Not all those pages have values. So, some of these pages are just blank. I need a code that activates the sheet, selects all the non blanks, and prints them out. The...

Hi folks, I'm new to this forum and an intermediate level user of Excel and VBA. I have made a rather simple code in my Excel 2010 workbook/VBA project to print one sheet and at the moment I continuingly run into this nasty problem: Excel occasionally gives me (only sometimes!) the error...

Hi. I made a command button that will print off tabs within a workbook. However, I am trying to make it so that this excel file can be print-ready, meaning everything is easy to read and doesn't flow into 3 pages when it can be condensed into one? The problem I am having is I want to make it so...

I have a form in Access which I need to print a hard copy. The checkboxes on this form look terrible on the printout if they are checked. Is there any fix for this? In other words, is there a way to make them acutally look like checkmarks? I'd take completely filled in over what's actually...

Hello all, I would like to be able to update the page number in a repeating print area and have a single printout command to produce a single pdf file. The print area is fixed and I know the number of pages (3). There is a cell where the user can input the first page number to be used. Here...

I've got a macro that loops through the charts on a sheet and exports them to jpg. That works, but for my purposes jpg quality probably won't cut it. So I've set it up to print to PDF. I've got it working so I have one chart on a page. That's what I want, but the issue is that the chart only...

I need to print out several tables based on some user input (I have the code for that bit and it works great). My problem is that I am not familiar with the PrintOut function. Here is that I have so far: If Sheet2.Range("P14").Value = True Then Sheet5.Range("A1:O25").PrintOut...