Article View: comp.apps.spreadsheets
Article #91Excel 3.0 page.setup() bug?
From: Mary.Curtin
Date: Sat, 11 Apr 1992 11:27
Date: Sat, 11 Apr 1992 11:27
26 lines
1331 bytes
1331 bytes
I am using Excel 3, running under Windows 3.0. I need to print 469 charts, so have been developing a macro to do this. All is well (the first chart prints) when I record the macro. Then I edit it, to put in a for loop (to extend it to do the other 468 charts). But when I try to run it, I get a ÔMacro errorÕ message (which asks whether I want to halt, step, continue or goto the error). The line which the error is reported in uses the page.setup function, to make the current chartÕs header and footer blank. I have checked the recorded statement, which is =PAGE.SETUP(Ò Ò, Ò Ò, .75, .75,.75,.75,2,FALSE,FALSE,2,9,) and I canÕt see any errors with the arguments. If, when the error comes up, I click the continue box, then the chart prints correctly. But doing this 469 times does not appeal! Anyone got any idea what the problem is? Suggestions for a fix? -- \ \/ / | \/\/\/\/ | mary.curtin@bbs.actrix.gen.nz
Technical Details
Message-ID:
<1992Apr11.112753.3724@actrix.gen.nz>Path:
arc1-ca.pugleaf.net!sparky!uunet!comp.vuw.ac.nz!actrix!Mary.CurtinShow Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets Path: arc1-ca.pugleaf.net!sparky!uunet!comp.vuw.ac.nz!actrix!Mary.Curtin From: Mary.Curtin@bbs.actrix.gen.nz Subject: Excel 3.0 page.setup() bug? Organization: Actrix Information Exchange Date: Sat, 11 Apr 1992 11:27:53 GMT Message-ID: <1992Apr11.112753.3724@actrix.gen.nz> Sender: Mary.Curtin@actrix.gen.nz (Mary Curtin) Lines: 27