Format Spreadsheet Macro

**Hovander** · 09-05-2012, 02:58 PM

Greetings,
Having trouble with what should be a simple macro.

All I want to do is set spreadsheet to the following.

Paper size: Legal
Orientation: Landscape
Print Area: 1 page wide by 3 pages tall

Pretty simple to record, however when I run macro it takes anywhre 45 seconds to 3 minutes to run.

Any and all help is greatly appreciated.

**mshale** · 09-05-2012, 03:07 PM

Please Login or Register  to view this content.

Try that. When you record, it does that loop - and what looks like hundreds of other steps - 3 times

**Hovander** · 09-05-2012, 05:04 PM

Almost worked.

On page setup the scaling is set to Adjust to:
Just need for it to set to Fit To:

**mshale** · 09-05-2012, 05:41 PM

ummm... that must be a 2010 bug/feature. The code clearly states that it's using "Fit to"

The only thing I could suggest, is record the macro on your end, and delete all of the lines above the last with statement and clean it up a bit and delete the useless lines. Record the macro yourself, and post all of the code here and I'll see what's different.