1. S

    VBA - Print Area Change (from a set range)

    I have an Excel template (wb1) containing VBA to print the set range of a sheet in another workbook (wb2) via a command button. Depending on the options chosen in wb1 will depend on which sheet w/in wb2 prints. The code works, but wk2 contains many sheets (each having their own print area set...
  2. M

    VBA macros for Printing

    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...
  3. D

    Changing UsedRange to PrintArea

    I'm trying to make a macro that exports the specified sheets as a PDF. Right now the code looks like this: Sub SaveasPDF() fileName = Sheets("Month Formatting").Range("A8") + " PDF" Sheets("Totals Sheet").Activate ActiveSheet.UsedRange.Select Sheets("Flare").Activate...
  4. B

    VBA, PrintArea ,Max Ranges

    Hi I need anyone's help :-) Here is my print area Each range is selected in each "FOR EACH" loop, The code stops at the range in red below is there a way to bypass the max range input i have 20 more ranges to input...
  5. H

    Setting print area to last value in column

    Hi all, I'm trying to create a print macro that would set the print area up to the last value in a specific cell. For example, in column A, if the last value is in cell A145 then the print area will be A1 to A145. This method will loop for the next 9 columns (A to J) if they have values...
  6. C

    PrintArea not respected in Excel French

    I have a c# program to printout a specific worksheet as seen below ------- Microsoft.Office.Interop.Excel.Application w_ExcelAppl = new Microsoft.Office.Interop.Excel.Application(); w_ExcelAppl.DisplayAlerts = false; w_ExcelAppl.Visible =...
  7. H

    Copying a Pre-Defined Print Area

    Hello- I am using Office 2010. I currently have an excel document with 40+ tabs. Each tab has already been defined with a print area. I am trying to copy the contents of the print area into a Word document to make it look more professional. I already have a excel Macro to run through each...
  8. P

    Concatenate printareas

    To the Excel/Printing expert, I made a macro for printing the 12 sheets (named 'jan', 'feb'...etc). Besides some user questions the macro has 12 times the following statement: (generated via the 'recording macro' function) Sheets("jan").Select ActiveWindow.SelectedSheets.PrintOut...
  9. A

    Set print range depending on # of rows in sheet

    I want to set a print range depending on how many rows in the sheet have content. The range ALWAYS starts at A1 and goes to column C, but the bottom row is variable. I thought the following code would do the trick (in the Excel worksheet section of VB): Sub SetPrintArea()...

Some videos you may like

This Week's Hot Topics