| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
I need the ability of printing everything in Column A next to everything in
Column Z without printing all the columns in between. How do I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
Hide columns B to Y, then select A to Z and print. Need the code?
Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
You can hide the colums you don't want to print.
rachelk wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
Yes, please
"Bill Pfister" wrote: Hide columns B to Y, then select A to Z and print. Need the code? Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
Sub PrintSomeStuff()
Dim wkb As Workbook Dim wks As Worksheet Set wkb = ThisWorkbook Set wks = wkb.ActiveSheet wks.Columns("B:Y").Hidden = True wks.Columns("A:Z").PrintOut wks.Columns("B:Y").Hidden = False End Sub "rachelk" wrote: Yes, please "Bill Pfister" wrote: Hide columns B to Y, then select A to Z and print. Need the code? Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
WHERE DO YOU ENTER THE CODE SO I DO NOT KEEP HAVING TO HIDE THE ONE COLUMN I
DO NOT WANT PRINTED? THANKS "Bill Pfister" wrote: Sub PrintSomeStuff() Dim wkb As Workbook Dim wks As Worksheet Set wkb = ThisWorkbook Set wks = wkb.ActiveSheet wks.Columns("B:Y").Hidden = True wks.Columns("A:Z").PrintOut wks.Columns("B:Y").Hidden = False End Sub "rachelk" wrote: Yes, please "Bill Pfister" wrote: Hide columns B to Y, then select A to Z and print. Need the code? Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
The line "wks.Columns("B:Y").Hidden = True" hides columns "B" through "Y". Is that what you're asking? "LEOPARDSHIDEAWAY" wrote: WHERE DO YOU ENTER THE CODE SO I DO NOT KEEP HAVING TO HIDE THE ONE COLUMN I DO NOT WANT PRINTED? THANKS "Bill Pfister" wrote: Sub PrintSomeStuff() Dim wkb As Workbook Dim wks As Worksheet Set wkb = ThisWorkbook Set wks = wkb.ActiveSheet wks.Columns("B:Y").Hidden = True wks.Columns("A:Z").PrintOut wks.Columns("B:Y").Hidden = False End Sub "rachelk" wrote: Yes, please "Bill Pfister" wrote: Hide columns B to Y, then select A to Z and print. Need the code? Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing
You can enter the code in
Private Sub Workbook_BeforePrint(Cancel As Boolean) LEOPARDSHIDEAWAY wrote: WHERE DO YOU ENTER THE CODE SO I DO NOT KEEP HAVING TO HIDE THE ONE COLUMN I DO NOT WANT PRINTED? THANKS "Bill Pfister" wrote: Sub PrintSomeStuff() Dim wkb As Workbook Dim wks As Worksheet Set wkb = ThisWorkbook Set wks = wkb.ActiveSheet wks.Columns("B:Y").Hidden = True wks.Columns("A:Z").PrintOut wks.Columns("B:Y").Hidden = False End Sub "rachelk" wrote: Yes, please "Bill Pfister" wrote: Hide columns B to Y, then select A to Z and print. Need the code? Bill "rachelk" wrote: I need the ability of printing everything in Column A next to everything in Column Z without printing all the columns in between. How do I do this? |
| 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 | |||
Linear Mode
