R
ryan.fitzpatrick3
I have several named ranges. I would like to print them out on one
page instead of them printing out on separate pages. Here's my code:
Sheets("Data").Select
Range("LA").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Richmond").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Joplin").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Calgary").Select
Selection.PrintOut Copies:=1, Collate:=True
I would like to print them out where the next named range prints out
underneath the previous one and maybe even have a row space to clean
up the sheet. Is this possible and what code should I use?
Ryan
page instead of them printing out on separate pages. Here's my code:
Sheets("Data").Select
Range("LA").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Richmond").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Joplin").Select
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Data").Select
Range("Calgary").Select
Selection.PrintOut Copies:=1, Collate:=True
I would like to print them out where the next named range prints out
underneath the previous one and maybe even have a row space to clean
up the sheet. Is this possible and what code should I use?
Ryan