Excel 3.0 page.setup() bug?

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mary.Curtin Sat, 11 Apr 1992 11:27

#91

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads