printing

Hi guys, I have the following code that runs through multiple sheets creating a named range/print area - to fit to one sheet in readiness for printing. It is successfully creating the print area/named range on each sheet (that has a numerical name) but it is not setting it up for printing on...

I have a routine to print a worksheet using Application.Dialogs(xlDialogPrint).Show This works fine if user is printing to a printer However - I want to allow the user to Print To PDF but save the PDF to a Specific Folder The Print to PDF works fine except I cant figure out how to default the...

This macro is to print a graph from a spreadsheet Sub Print_Graph() ' ' Print_Graph Macro ' ' Application.ScreenUpdating = False Application.Goto Reference:="AM_Graph" ActiveSheet.PageSetup.PrintArea = "$A$2:$DW$57" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True...

Hi, Each month I download a csv overview of creditcard expenditures and save it as an xls file. On each line I add the word "link" in column K. I then add a link to the receipt. I am on a mac. [The linked receipts are stored in a Devonthink database, the links open the relevant document...

Hi all I have searched the internet on this problem but so far I have not found the answer that suits my needs. I want to create a macro with a message box that prompts the user to select a range on the worksheet to print after the user selects all of his printing options. Below is my...

Hi there I'm not sure if this is possible or not to do in Excel. Is it possible for me to set up my printing options first and then run a macro to print out the data that I have chosen before hand. I could have chosen only a selection or the whole worksheet etc. I know that I can record a...

Hi, I would like my code to check for a value in cell N18 before printing. No value then do not print. If there is a value then continue to print. The code in use is shown below. I leave the cell empty. I see the msgbox. I click on OK Printing then continues. What did i miss thanks. Private...

I want set a macro to print all tabs of a workbook, except for the first 3. The first 3 never change, so I know their names, but they're length does, so it's difficult to use code that starts printing on a particular page, in case one of the first 3 takes up a different number of pages than it...

I have a macro to export and save the table to a PDF. However, it is only exporting the data rows. The pdf doesn't show the header row and total row. Sub PrintMileage() Dim ws As Worksheet Set ws = ActiveSheet Dim tbl As ListObject Set tbl = ws.ListObjects(1) tbl.Range.Select...

Is there ban easier way to cut and paste a long document only printing the first three columns on one page?

Hi All - OK - I got a baffling problem. I have a conditionally formatted cell that "shows" a title if another cell has a value in it or appears "blank" if there is no value in that other cell. The "blank" is just a white font selection. Here's the issue - on the screen it is working...

Hello everybody, I am experiencing an issue in Excel which I cannot solve by myself. I find myself with 1280 columns with the first two rows (1, 2) filled with data: For printing reason, I need to move all the data under columns A, B and C: Thanks a lot for your help and suggestion! BC

I'm trying to use vba to print 54 tabs from a separate xlsx sheet. I've been able to get it to work. The only issue is that the list of 54 tabs is too long and causes an error. I can print, say, 30 tabs without an issue, but 54 is too many. Can I group the tabs at the top of the code? I've done...

I have a cell that is highlighted yellow if a checkbox is checked. I want to restrict printing if this cell is still highlighted, but my macro is not working. My code to highlight (fill) the cell based on whether a checkbox is checked is as follows: <code style="margin: 0px; padding: 0px...

I'm using Excel2007. With the exception of my headers, only column AC (sometimes) wraps to multiple lines based on input data. Several columns are protected. Rows 1 thru 3 and cols A & B are frozen to always be visible. How can I print only certain cells & only in rows with increased row...

Hello! I've run into difficulties with coming up with a macro. I'm really just a begginer, but I hope someone could help O:) What I need would be a macro that could print multiple times. The idea is, that on a sheet I would have a list of - let's say - codes of products which I would manually...

Is there any way, without a macro, to get Word to print the name with the comments rather than the initials (especially since it seems to put the inititals in backwords e.g. Tom Smith's inititials would show up as ST) And is there any way to make sure all the comments are printing as sometimes...

Hi... I'm new here and I do Graphic Design. Does anyone know of a formula I can use for a commission structure? Whatever the cost to print is, I need a formula that looks at the value in that cell and calculates the correct commission flat rate or percentage in the commission cell. Printing...

Hi everyone, I have folders for each of my students containing a spreadsheet with their performance. every week i have to open up each individual file and print out 2 specific sheets from each file, week x and week x progress report. it usually takes me all morning, but I was wondering if there...

I am trying to run the macro below, but it doesnt seem to be printing. What is wrong with it ? Option Explicit Sub test() Dim i As Integer i = 1 While Sheets(2).Cells(i, 1).Value <> "" Sheets(1).Cells(1, 1).Value = Sheets(2).Cells(i, 1).Value Sheets(1).PrintOut...