Posted to microsoft.public.excel.programming

[email protected] sven.lowry@gmail.com is offline

external usenet poster

Posts: 1

Setting horizontal print area

I have a number of spreadsheets with varying column and row counts.
When I switch to pagebreak view in Excel, it automatically sets all the
rows to be in the print area, but not the columns.

Using VBA, how can I set the print area to cover the last column with
data in it?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
setting print area	Nick Smith[_2_]	Excel Programming	3	April 26th 06 10:39 AM
Setting The Print Area	beans_21	Excel Programming	3	January 10th 06 09:32 AM
Setting Print Area	Defoes Right Boot	Excel Programming	3	May 18th 05 12:26 PM
Setting print area with vba	KimberlyC	Excel Programming	3	December 18th 04 12:46 AM
Setting print area	Don Guillett[_4_]	Excel Programming	0	September 4th 03 02:14 PM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us