printing macro

Hello, This may be a bit of a long shot, but I have been using HP ePrint to print a an excel spreadsheet using the email to printer function and found that it doesn't work 100% of the time. Intermittent issues are always such a ball ache, so I'm trying to think of an alternative solution. The...

As you can tell the code below prints of the sheets that contain data in them. The trouble im having is about half way down there are some print settings that are only working on the active sheet. Im unsure what to replace the active sheet with so it will apply all the printer settings listed to...

I have some existing code that automatically prints a copy of a worksheet in my book #code Sheets("NMR Form").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ IgnorePrintAreas:=False #endcode Instead of automatically printing, I would like the user to...

I have no coding experience, but hoping this is a really easy fix. Here's what I'd like to do: Print worksheet from multiple printer trays at once (network printer). Right now, I have to hit "print", then do it again, but change the output tray. I print from 4 different trays every time I...

I would like to print a worksheet changing only one field/cell (B27) with information from another worksheet ranges A1:A100. If there is no information in cell, would like it to skip.

My first time posting here and my first foray into VBA. I’ll try my best to be as descriptive and accurate here.... I have 2 tabs: “Customer Info” tab: this contains customer data in a table (name, address, etc.) that will be manually updated / input as needed. This customer data is then...

Hello everyone, I am having difficulties. I have a workbook with several worksheets, Sheet 1, Sheet 2, Sheet 3. But some workbooks have Sheet 3 missing, so therefore I want my macro to skip that worksheet and continue. Here is what I got so far. Sub SpecficSheets() Dim wb As Workbook, ws As...

Hello, I need help with a printing macro. I have 4 sheets labeled "FINRA PV" and "FINRA Download" along with its corresponding months, and would like to automatically print all of them. However, I change the name of one them every month. Currently this is what I have: Sheets("FINRA Jul...

In my excel forms that I have created, I have my people using additional tabs to embed information (photos, receipts, statements, etc). The finished report is then distributed. My question is this: Is there a macro I can use to print these statements, receipts, etc. automatically. I know...

Hi there, fairly new to macro's but I need some fairly complex coding for a project I'm working on. Basically I need a macro to do the following, Select the next item down on a drop down box, print to PDF using CutePDF as the printer and finally at the 'Save as' stage, use a cell within the...

Hello I am having trouble achieving the following and have searched through the forums without a clear answer. I have an excel document with 16 worksheets and a front page. On this front page I want to include a list that has the numbers 1-16 on it but in a different order (not alphanumerical)...

Hi, I'm in need of some help regarding printing in excel with a vba code. At the moment I have a checkbox which pops up when you click the "Print" button I created on the sheet. But once you have selected the sheets you want and hit "OK" it goes straight through to the printer. I'm...

I have a list of products that I have employees use as a reference sheet to confirm item # with the right product. The sheet is set up as column A - item # column B - Item name column C - Small picture of item column D - how to package it As I need to add/remove products from time to time I...

I would like to make a worksheet for a material requisition but only print the line on the worksheet if the quantity required is greater than zero The blank worksheet would contain columns as follows Qty Required : item stock # : description : Weight : Cost : Extended Weight : Extended Cost ...

Hi, I'm hoping someone can help me, I am making a batch card for work, that shows a batch number and weight that is fixed but changes for each tonne printed off. I have used a user form to get the number of tonnes etc. and need it to print on each card tonne numbers up to the amount entered...

Hello Forum goers, I need help with building a macro to accomplish a complexed wish list. Tried numerous other solutions and tried combining some but could not get the needed result. I deleted rows from the worksheet so it would fit better and hopefully easier to follow; the far right...

Hi all! I have looked through a tun of threads about print macros, but none of them are quite what I'm looking for. First of all, I am using Excel 2010. I have a workbook that has roughly 150 worksheets in it with information for each of my employees. I am looking to set up a macro that will...

Hi, Below is my code that will loop through a workbook and print each worksheet individually. I'm now trying to add code in order to find worksheets with the same account number in the sheet name and group them - then print, and move on the the next account... below is an example of 2...

Hi all, I produce a monthly pack which requires multiple worksheets in different excel files to be selected and printed (over 100pages). What I need to do is activate a workbook, select the required worksheet(s) then print, then go to the next workbook. For example, open up Report A file...

I'm having a bit of trouble getting Excel to play nice with the way I want a spreadsheet to print, stemming from a desire to have the print format look a bit different than the way it's displayed in Excel. The spreadsheet looks like this: ...and when I print it now, with the print areas...