RightMargin = Application.InchesToPoints(0.7) LeftMargin = Application.InchesToPoints(0.7) Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlDiagonalDown).LineStyle = xlNone 'Delete temp worksheetĪpplication.DisplayAlerts = FalseĪpplication.DisplayAlerts = TrueĮnd Sub Ws.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False Ws.Range(rngArea.Address).Value = rngArea.Value RngArea.Copy Destination:=ws.Range(rngArea.Address) 'Copy each selectionįor Each rngArea In rng.Areas

Sub Print_MultiAreas()ĭim rng As Range, ws As Worksheet, rngArea As Range Second Macro (to print one section of the spreadsheet) - i selected teh cells after starting to record the macro

Selection.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False Is it to do with selecting the cells before i record the macro?įirst Macro (to print 2 separate areas together) - i selected the cells before starting to record the macro I'm sure it's something simple but i don't know VB - am only a low level excel user. I compromised by printing one whole area (which will include info i don't want - but if that is the only way to do it) - but i keep getting a bug - Run-time error '1004': Application-defined or object-defined error. Ideally i'd like it to print 2 different areas together - but when i set that, it sets it to 2 pages even though all the original data is only on one page. I am having trouble setting up a very simple macro to print a selected area of a spreadsheet.

Google sheets print selection