EXCEL Macroproblem

Article View: comp.sys.ibm.pc.misc

Article #1651

Back to comp.sys.ibm.pc.misc Previous Next

#1651

From: Wagner Hermann
Date: Wed, 09 Sep 1992 13:47

16 lines
1020 bytes

Hello World

I'm sitting here and have some serious problems with Excel 3.0 Macros.
It is not possible to me to procede functions like TREND() or RGP() in macros.
If I assign this functions to a tablecell is works fine, but in macros
nothing happened.
My second problem is to use variables in functions. Especially the functions
TREND() and RGP() which writes its results in arrays. The "known_y_values" and
the "known_x_values" are not fix and should be variable.

I hope my cry for help is heard by a specialist.
Please help me

Hermann

wagner@rzmain.rz.uni-ulm.de

Technical Details

Message-ID: <1992Sep9.134701.11640@wega.rz.uni-ulm.de>

Path: arc1-ca.pugleaf.net!sparky!uunet!usc!sol.ctr.columbia.edu!ira.uka.de!news.belwue.de!theorie!news.uni-ulm.de!news

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.ibm.pc.misc
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!sol.ctr.columbia.edu!ira.uka.de!news.belwue.de!theorie!news.uni-ulm.de!news
From: WAGNER@rzmain.rz.uni-ulm.de (Wagner Hermann)
Subject: EXCEL Macroproblem
Message-ID: <1992Sep9.134701.11640@wega.rz.uni-ulm.de>
Sender: news@wega.rz.uni-ulm.de (News Net)
Organization: University of Ulm, Germany
Date: Wed, 9 Sep 1992 13:47:01 GMT
X-News-Reader: VMS NEWS 1.24
Lines: 16