macro for page setup

Posted by Butch on May 04, 2001 2:10 PM

I am using the same spreadsheet for running several different reports. Each report requires a different page setup--different paper, header, etc. When I include the page setup in my macro it takes forever to run (and maybe never will run). What can I do to overcome this?

Posted by Dave Hawley on May 06, 2001 2:29 AM

Hi Butch

This is a common problem with VBA and Page setup. Even more so when you include the margin settings.

I would suggest you have a look at "Custom Views" and "Report Manager". Both these can be found under "View". If "Report Manager" is not there you will need to install it. Go to Tools>Add-ins-Report Manager.

These two features are desinged fo keeping page setups and will always operate much quicker than a macro.

Dave

OzGrid Business Applications