print range

Hi, Almost there but not quite! Bit of a newbie on the VBA besides what I have gleaned off this site and others. Goal - set a consistent print range across multiple worksheets. The issue I have is that it doesn't seem to work lol. So far - I have defined the worksheet names on the 'Input'...

Having looked through a number of posts I am unable to find code to help. The problem is I need to select a print range on a rolling 13 week basis based on the columns. Currently the page is set up to repeat column A which contains the headings/categories on every page. I need to change which...

Please help if anyone has any ideas; I have set up an offset to make my print range dynamic (Offset($F$1,o,o,$J$1,4) so as the table expands the print range expands. CountA(I:I)+4 is in J1 to get row count. This works great, however, each month I copy the table and insert the copy in front of...

I was hoping to get help with VBA Code that when a Active X comand button is pressed, range D1 to E25 will print in landscape.

Hi, I'm not sure how this happens but sometime when I try to print an excel spreadsheet and I select print all column on one page it would print super tiny because it would include blank cells. I have check the following to ensure this was not causing the issue: Make sure there is no white...

I have one simple worksheet in a workbook. It consists of three print ranges. ++++++ Now I have a custom print button: Sub Button27_Click() Application.ScreenUpdating = False Sheets("sheet1").Visible = True Sheets("sheet1").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$E$120"...

Hi I have a spreadsheet that is showing a roster and we want to print 2 months at a time. Is there a way I can set up a macro to print from todays date for 2 months. this spreadsheet is very basic the columns are made up of year day date persons person and then the last one being notes...

Hi, I am looking for a code which can select two seperate print ranges within the same worksheet. For example, I would like to print A1:C10 and A15:F40, with one macro. I do not want the code to simply print twice selecting a different range each time, as I want to print this as an Adobe...