Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrap columns to print in rows
I have 5 rows of day that grows by a column every two weeks. Each payroll
period end date produces the new column and the information in the rows below. It is only 5 rows and at this time will print all the columns on one page. Can I tell it to print columns A thru J and then print K thru R on rows 6 thru 11 and then S thru AB on 13 thru 18? try to wrap the window to keep all the information on one page. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrap columns to print in rows
Jenn
You would need VBA programming to do this. Essentially, you would have a macro that you would execute be any one of several means. That macro would copy all your date to another sheet, then arrange the data in that "other" sheet like you want, and then print. Do you know that your column ranges are not the same width? Is that what you want? Your first range, A:J is 10 columns, as is S:AB, while K:R is 8 columns. The following macro does what you want, using 10 column brackets. Post back if you need more. HTH Otto Sub PrintAll() Dim TheRng As Range Dim c As Long With Sheets("PrintSht") .Cells.ClearContents Cells.Copy .Cells(1, 1) Set TheRng = .Range("A1:J5") For c = 1 To 50 If Not IsEmpty(TheRng.Offset(, c * 10)(1)) Then TheRng.Offset(, c * 10).Copy .Range("A" & Rows.Count).End(xlUp).Offset(2) End If Next c .Range("A1", .Range("A" & Rows.Count).End(xlUp)).Resize(, 10).PrintOut End With End Sub "jenn" wrote in message ... I have 5 rows of day that grows by a column every two weeks. Each payroll period end date produces the new column and the information in the rows below. It is only 5 rows and at this time will print all the columns on one page. Can I tell it to print columns A thru J and then print K thru R on rows 6 thru 11 and then S thru AB on 13 thru 18? try to wrap the window to keep all the information on one page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excell does not print rows or columns | Excel Discussion (Misc queries) | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
How do I get to print my spreadsheet (8 columns x 100 rows) on an. | Excel Discussion (Misc queries) | |||
Can I wrap rows of print? | Excel Discussion (Misc queries) |