🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #91

Excel 3.0 page.setup() bug?

#91
From: Mary.Curtin
Date: Sat, 11 Apr 1992 11:27
26 lines
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.Curtin

Show 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