Print Macro help

ctc005

New Member
Joined
Jul 20, 2007
Messages
15
Hey all,

I am trying to set a print macro to do the following:

I have a worksheet that when printed on landscape is the height of one page and the width of 10 (hope that makes sense). I want all ten of these pages to print column A. Column A possess my "headers" for the information and want it on each page as a reference in the report printing. That is all I need from the first worksheet in my workbook. For the second page and other half of my report I need the same done, where column A is printed on each page, but the width of this one is variable and the height is equal to two pages this time rather than one. I want it to print in this fashion:

1 2 3 4
5 6 7 8
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
For the first part you can goto Page Setup-->Sheet-->Columns to Print at the Left.

For the second check out "Print a Custom View" in the helpfile.

HTH,

Smitty
 

ctc005

New Member
Joined
Jul 20, 2007
Messages
15
For the first part you can goto Page Setup-->Sheet-->Columns to Print at the Left.

For the second check out "Print a Custom View" in the helpfile.

HTH,

Smitty

smitty thank you for your help. i'm trying to set up a macro so that the customer can use this excel sheet without going through all of that. Perhaps I can try your suggestion and record the macro, but I was looking for some code input if anyone had any.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
The easiest thing will be to record a macro doing what you want, then assigning it to a button.

Feel free to post what you come up with and someone can clean it up for you.

Smitty
 

Forum statistics

Threads
1,181,659
Messages
5,931,273
Members
436,786
Latest member
Deniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top