Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the code I need to write in order to:
1. Print the first page of an active worksheet? 2. Print a selected range (A1:B5 for example) of an active worksheet? Thanks. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1 1st page of active workBOOK
sheet1.printout 2 activesheet.range("a1:b5").printout -- Don Guillett SalesAid Software "amirstal" wrote in message oups.com... What is the code I need to write in order to: 1. Print the first page of an active worksheet? 2. Print a selected range (A1:B5 for example) of an active worksheet? Thanks. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1.
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1 2. Range("A1:B5").Select Selection.PrintOut Copies:=1 Mike F "amirstal" wrote in message oups.com... What is the code I need to write in order to: 1. Print the first page of an active worksheet? 2. Print a selected range (A1:B5 for example) of an active worksheet? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very basic VBA question. | Excel Discussion (Misc queries) | |||
Basic question | Excel Discussion (Misc queries) | |||
Basic VBA question... | Excel Programming | |||
Basic question | Excel Programming | |||
Basic VBA question | Excel Programming |