print areas

Hi All, I need some help with this one please. I have a spreadsheet that is a schedule, it lists week by week until the end of the year, this helps us plan out future works but we only send 2 weeks worth to a client. once the current week is over, we 'hide' the week, which in turn moves the new...

Hello, I am very new to VBA and I am looking to create a macro to define the print area for each worksheet in my workbook. Currently this is the code I am using and it is assigned to a button; the trouble I have is that instead of setting the print area to the last cell of each worksheet (the...

I know just enough VBA to be dangerous. I have a generalized spreadsheet with a summary report page. The data to be printed from the summary page varies. Therefore I'd like to build the PrintArea dynamically. As usual I've found several helpful hint on the web but can seem to tie it all...

Hi, Currently I am going through the process of opening up an excel attachment within an email in order to set the print areas so that when PDF'd it will be converted in a readable manner, as per the excel sheet. Ideally I would be capturing the original email too. Is there a way possible...

Anyone had to deal with this before? So I want to be able to print my Document in various formats. In a Userform are two option, one to print 1 page high x #of pages wide (as required), then other to split it at x-row (which is dynamic based on the formatting of the sheet) The following code...