printing

New to this forum and a rookie at Excel VBA. I have a spreadsheet that I am trying to use to scan in a varietyof parts into the spreadsheet, sheet 1. Then on a separate sheet, sheet2, I am searching the Tablerow 1 from sheet 1 for a particular part number. Then based on that part numberI am...

Hi everybody, I am looking for a code, which creates a Pdf from the active sheet (specific range), so you can print that Pdf. Is there a way to do that without specifying a path where to save the file because it is only needed for printing? Thanks for your help! Best regards, Nawid

Is there a way to create a document footer as opposed to a page footer in Excel? I want the footer to show up only after the last page. But it keeps printing it on each page.

I currently have an employee database which is based on Excel. Sometimes, we need to print off employee information for only a handful of employees. When this occurs, normally the admin just copies and pastes each employee record into a new sheet which takes a while as it means trawling through...

Hi, Is it possible with Black & White printing in Excel to make specific cells still print in colour ??

I have a worksheet where the background color of the sheet (using fill color) is tan like color, but when the user goes to print the worksheet I just need it to print with no fill, but I want it to change back to the original fill color when printing is done. Thank you

Hi everyone, I have a safety evaluation sheet that every employee completes every month. I am currently printing off copies and hand writing their employee numbers across the top. Is there a way to get Excel to print one sheet with the different employee numbers? I found how to get it to...

Hi I am trying to make a cover page with a picture filling the whole page. I would like the cover page to: a) be automatically added as the first page, when printing a worksheet (report), and b) have title and headlines automatically filled depending on which woorksheet/report I choose for...

HI Can any one save me !! I have a sheet which populates with information (the info that populates changes in the number of rows but the columns are generally set I would like a VBA which Specifies the fix columns for printing for example column B to F I would like it to specify the first...

Hello, I work in excel everyday but I have changed computer lately and one of the things I cannot change is the printing colour sets! Before I was able to print colourful images and colourful shapes for example, and the highlighted cells (that help me hot to calculate things) were being...

We are familiar with repeating columns on the left feature However, the state is requiring that in these workbooks we are printing that the last four columns be printed on every page exactly as they appear For example columns a,b,c,d,e,f,g,h,i last 4 columns w,x,y,z The last 4 columns...

Hello, I am needing help printing sequential invoice #'s on a 3 part NCR form. I am currently changing each # by hand before printing, and this is so time consuming. I know there has to be a way that I can open my form and tell excel to print 3 collated copies starting with #1001 and ending...

I have the code below in a userform that I need a little help with. I need the code to have like black and white, 11 x 17, zoom 90, landscape, print range and also I need it to go to a specific printer. Im not really sure how to get any of that information. Thanks as always for the help...

Friends, I got this code to enable Print Preview of selected range. However, if pressing 'Close Preview' or even finishing printing I obtain an error. So apparently code contains a missing link. I do need Print Preview dialogs because user should be able to modify printing options. Sub...

Hello, I've got a macro for printing labels. I need the cursor to go to the last non-zero in column C after capturing the information and printing the label. I wrote this macro with the macro recorder. So, I know that I'll have to hard-code this last function. I don't know how to do this in VBA...

i would like to have some advice when printing large documents with excel 2013. while making a file about 1300 lines long i wanted to make it so that when i print this file that text isnt cut off by the page ends for example i like cake <-------- i...

Hello all! I am new to this message group and am hopeful that someone here can help me regain hours and hours of my time. I am currently tasked with producing packing lists and pick tickets for jobs outside of our system (don't get me started on that) and have been utilizing vlookup to do so...

Hello, I'm looking for some help with a macro please. At present the macro performs the following: 1. Unprotects the active worksheet. 2. Filters the active worksheet to hide blank lines. 3. re-protects the active worksheet. 4. Resets the page breaks on the active worksheet so there are no...

Hello, when i set page title to print each page then i found in printing preview it need to print empty pages also, one more thing, it didn't include new rows in the printing (i.e. it didn't increase the no. of pages to cover the new data). appreciate the help. Thanks:)

Hi there, I've run into a bit of an issue with an excel I'm working on and was wondering if anyone here might have some input. Here we go... I have a freeze pane set up on row 6 - followed by default unchanging data from rows 7 all the way to (currently, and will change) row 21073. Default...