| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing A Range
Is there a way to print this range without page set up
If [I55] 0 The Range("A52:I67").Selec ActiveSheet.PageSetup.PrintArea = "$A$52:$I$67 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=Tru ActiveSheet.PageSetup.PrintArea = " End If |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing A Range
Bob,
How about... Range("A52:I67").Select Selection.PrintOut Regards, Jim Cone San Francisco, CA "Bob" wrote in message ... Is there a way to print this range without page set up. If [I55] 0 Then Range("A52:I67").Select ActiveSheet.PageSetup.PrintArea = "$A$52:$I$67" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True ActiveSheet.PageSetup.PrintArea = "" End If |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing to a range and printing value | Excel Discussion (Misc queries) | |||
| Printing same spreadsheet range getting different output | Excel Discussion (Misc queries) | |||
| Printing a named range | Excel Discussion (Misc queries) | |||
| printing only active range (changing) | Excel Discussion (Misc queries) | |||
| Printing based on a value of a range | Excel Programming | |||
![Bob[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
