print

Hey there, I am trying to create a macro that will "read" the range from a cell such as "02" (A1:M39) and export that range as a PDF, however I have only been able to set the range directly in the VBA code, is it even possible to have it read a range that changes dynamically? For comparison...

Hello all, When I am trying to print, the pages contains too much white space and doesn't take up the entire page or have my data too small. Please advise what I can do. For the first tab, I am trying to print the data onto 3 pages(portrait) but there is too much white space. How can I have...

Hello, I have multiple files with varying working and backup sheets but I would like to create a macro that will print the main group of tabs which will always vary in actual names. My initial thought was to create marker workbooks named 'start' and 'end' for example that would mark the...

Hi, Can someone explain to me how I can get my print area centered out over the whole page? Currently it leaves most of the page blank, but I want it to be spread out whilst keeping to fit the sheet on one page.

Hello, I am putting together a string, and using the print statement to output to a file. I have an equation in the cell that I want to print out. The equation results in a string. That string has general characters, and spaces in it, and looks fine in excel. I use the following to print to...

I read several threads here and they seemed really close to what I need but not quite close enough. I have the following existing code that prompts the user to answer Yes or No when asked if they need to print the NMR form. I would like to add code if they say Yes, it asks how many copies are...

I administer an MS Access DB with approximately 20 end users. Each user has a copy of the FE on their desktop. When I need to make changes, the Form_Load Event of the initial form identifies that a new version is available and runs a batch script to copy down the new version of the front end to...

Seems our engineering friends at Microsoft are at it again. They love breaking things that work perfectly. I have a workbook with about 70 identical sheets. I wanted to print the same rows on each sheet. Well in the 2013 version you can no longer set the print area on multiple sheets. Fine, I...

Hi Everyone, OK not come across this one before but heres what i need. I have a sheet with 3 different Ranges Range B2:F10 Range J7:T37 Range AA3:AT40 Now the problem im having is I want these ranges to be my Page sizes but when i print i get everything shrunk to match the width of Range...

hi, every one i have data in sheet1 begins from a2: f38 the empty data begins from a17:a32 i just would code print the filled data and ignore the empty data if a17:a32=""

When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...

I am looking for a way to print a returned array for a specific criteria. For example, if the following values in a column do not equal 0, I would like to return them and print them in another column. I do not want to use a Macro. i.e. 0 0 0 0 Apples 0 0 Oranges 0 0 Values...

Hello to all, I have the below macros IncomingProducts and RunAgain. - IncomingProducts: This macro simulates the input coming from users of StoreA and StoreB. For example purposes I've show the data entries from both stores with arrays. - RunAgain: This macro only calls IncomingProducts to...

I want to be able to click a command button and the macro will open another work book and print the first 3 sheets in the new workbook This is what I got so far Private sub commandbutton_click() If Range("A1").value=4 then Workbooks.open "c:\work\april\ivan\dinner\reciepts.xlsm"...

hello all, i have a worksheet with column A-I, row 1-250. however i'm not necessary to use every row every time. the question is how can i simply set the print area automatically to last row thus i can use less paper?:rofl: it seems my code below will goto row 250 every time and i will print...

Good day, I have a three checklists with a lot of checks for a specific equipment, Sheet 1, 2 and 3. The only cell value that should change on the checklist is the equipment number which is in cell A3. When i run the print macro, it should print out (a preview) the checklist based on the...

Good afternoon, I have a spreadsheet that is a continuous log of data with dates and times. I am dynamically changing the footer based on the user's selection and including the selected date range for the report as part of the footer. This is all working fine. What I would like to do is...

Hi folks, We have a report which consists of 10 sheets. Several of the sheets may vary in the number of pages that print. For example sheet 4 in the series may print 1 or up to 5 pages (varies with each report). For example: Sheet 1 - 1 page Sheet 2 - 1 page Sheet 3 - 1 or 2 pages Sheet 4 - 1...

Hi. I have a file with data on two separate worksheets. They need to stay on separate worksheets. But I need to print both worksheets on a single page, without scaling either. They're not large, they will both fit onto a single sheet without scaling. I did an internet search, my friend...

Hello folks. I have a problem with adding a watermark. I have followed the instructions given by a number of people on the web (including microsoft) and on this forum and added my jpeg into the header of my worksheet. In print preview, it looks perfect, but when I print, the watermark obscures...