printarea

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

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

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

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

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

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 =...

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

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

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()...