![]() Ws.Range(rngArea.Address).Value = rngArea.Value RngArea.Copy Destination:=ws.Range(rngArea.Address) 'Copy each selectionįor Each rngArea In rng.Areas Set ws = Worksheets.Add(After:=Sheets(Sheets.Count)) 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |