Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
I would like to always print only c5 and only F9:M9 with the range I am selecting for priting. How can I do that? for the moment if I write ..... If PrintSmokingForm.Step1.Value = True Then Range("c5", "printstep1").PrintOut Copies:=1 Else If PrintSmokingForm.Step2.Value = True Then Range("c5", "printstep2").PrintOut Copies:=1 Else ..... it prints all areas between c5 and my "printstep1" area. As always thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
If you want these to appear on one printed page, you will need to print as
you are doing now, but hide the rows and columns you don't want to appear in the printed page. -- Regards, Tom Ogilvy "Caroline vincent" wrote in message ... I would like to always print only c5 and only F9:M9 with the range I am selecting for priting. How can I do that? for the moment if I write .... If PrintSmokingForm.Step1.Value = True Then Range("c5", "printstep1").PrintOut Copies:=1 Else If PrintSmokingForm.Step2.Value = True Then Range("c5", "printstep2").PrintOut Copies:=1 Else .... it prints all areas between c5 and my "printstep1" area. As always thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
Thanks.
While you are around....could you answer this one too? And if I want to print the name of the sheet on all printed pages? Thanks -----Original Message----- If you want these to appear on one printed page, you will need to print as you are doing now, but hide the rows and columns you don't want to appear in the printed page. -- Regards, Tom Ogilvy "Caroline vincent" wrote in message ... I would like to always print only c5 and only F9:M9 with the range I am selecting for priting. How can I do that? for the moment if I write .... If PrintSmokingForm.Step1.Value = True Then Range("c5", "printstep1").PrintOut Copies:=1 Else If PrintSmokingForm.Step2.Value = True Then Range("c5", "printstep2").PrintOut Copies:=1 Else .... it prints all areas between c5 and my "printstep1" area. As always thanks in advance. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
In Excel 2000 at least, if I go into View=Headers and Footers, then create
a custom footer (or header), the last icon on the right inserts the tab (sheet) name in the footer &[tab] So I would just set up a custom footer or header. -- Regards, Tom Ogilvy "caroline vincent" wrote in message ... Thanks. While you are around....could you answer this one too? And if I want to print the name of the sheet on all printed pages? Thanks -----Original Message----- If you want these to appear on one printed page, you will need to print as you are doing now, but hide the rows and columns you don't want to appear in the printed page. -- Regards, Tom Ogilvy "Caroline vincent" wrote in message ... I would like to always print only c5 and only F9:M9 with the range I am selecting for priting. How can I do that? for the moment if I write .... If PrintSmokingForm.Step1.Value = True Then Range("c5", "printstep1").PrintOut Copies:=1 Else If PrintSmokingForm.Step2.Value = True Then Range("c5", "printstep2").PrintOut Copies:=1 Else .... it prints all areas between c5 and my "printstep1" area. As always thanks in advance. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
Seems obvious...
Thanks a lot -----Original Message----- In Excel 2000 at least, if I go into View=Headers and Footers, then create a custom footer (or header), the last icon on the right inserts the tab (sheet) name in the footer &[tab] So I would just set up a custom footer or header. -- Regards, Tom Ogilvy "caroline vincent" wrote in message ... Thanks. While you are around....could you answer this one too? And if I want to print the name of the sheet on all printed pages? Thanks -----Original Message----- If you want these to appear on one printed page, you will need to print as you are doing now, but hide the rows and columns you don't want to appear in the printed page. -- Regards, Tom Ogilvy "Caroline vincent" wrote in message ... I would like to always print only c5 and only F9:M9 with the range I am selecting for priting. How can I do that? for the moment if I write .... If PrintSmokingForm.Step1.Value = True Then Range("c5", "printstep1").PrintOut Copies:=1 Else If PrintSmokingForm.Step2.Value = True Then Range("c5", "printstep2").PrintOut Copies:=1 Else .... it prints all areas between c5 and my "printstep1" area. As always thanks in advance. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |