Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
printing Union of Ranges
Hello
I can't figure out why this doesn't work. It gives a PrintPreview of my whole table, A1:N27. What I want is a table with 6 adjacent columns A B C D G H. Dim Range1 As Range Dim Range2 As Range Dim RangeCombined As Range Set Range1 = Range("$A$1:$D$27") Set Range2 = Range("$G$1:$H$27") Set RangeCombined = Union(Range1, Range2) ActiveSheet.PageSetup.PrintArea = RangeCombined ActiveSheet.PrintOut preview:=True thks anny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
printing Union of Ranges
Hide cols E & F
-- Gary''s Student "anny" wrote: Hello I can't figure out why this doesn't work. It gives a PrintPreview of my whole table, A1:N27. What I want is a table with 6 adjacent columns A B C D G H. Dim Range1 As Range Dim Range2 As Range Dim RangeCombined As Range Set Range1 = Range("$A$1:$D$27") Set Range2 = Range("$G$1:$H$27") Set RangeCombined = Union(Range1, Range2) ActiveSheet.PageSetup.PrintArea = RangeCombined ActiveSheet.PrintOut preview:=True thks anny |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
printing Union of Ranges
Also make the range contiguous.
-- Gary''s Student "Gary''s Student" wrote: Hide cols E & F -- Gary''s Student "anny" wrote: Hello I can't figure out why this doesn't work. It gives a PrintPreview of my whole table, A1:N27. What I want is a table with 6 adjacent columns A B C D G H. Dim Range1 As Range Dim Range2 As Range Dim RangeCombined As Range Set Range1 = Range("$A$1:$D$27") Set Range2 = Range("$G$1:$H$27") Set RangeCombined = Union(Range1, Range2) ActiveSheet.PageSetup.PrintArea = RangeCombined ActiveSheet.PrintOut preview:=True thks anny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing ranges not remembered | Excel Discussion (Misc queries) | |||
automate printing different ranges on 1 worksheet at different tim | Excel Discussion (Misc queries) | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |