I am trying to put together a macro that will print only sheet (Engineering E10 to P53), sheet (Load Data A1 to N38) and sheet (Proposal A1 to the last cell with text). The sheet "Proposal" could possibly have multiple pages so I never know the bounderies of the print area. I would like to create a print button to execute this macro. The print button I will need on all the pages. Is this possible? Any help would be appreciated. Thank you . Happy New Year.
Try this workbook with your data.
Excel is giving me fits with this line. The program wont execute and I get a yellow error line on the displayed code.
Sheets("Proposal").Select
ActiveSheet.PageSetup.PrintArea = "A1:N" + Range("a" & Rows.Count).End(xlUp).Row
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
End Sub
There is a runtime error 13, type mismatch.
Last edited by cadamhill; 12-31-2012 at 01:36 PM.
Sorry it should read
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks