Excel: using array references returned by macros

Article View: comp.apps.spreadsheets

Article #177

Back to comp.apps.spreadsheets Previous Next

#177

From: Joel Horn
Date: Fri, 02 Oct 1992 22:02

12 lines
1145 bytes

What is the correct way to use an array reference in a cell which is the
result of a function macro call?  The macro calculates three related values
which I thought could (should?) be returned as an array, which I could then
use in further calculations (via INDEX(), maybe).  However, I can't get
INDEX() or any other function to fish the values from the array reference.
Please explain the correct method or point me to a (helpful) section in the
manual or the "Mastering Excel 4" book.  Thanks.
-- 

Joel Horn                          joel@travis.ssd.csd.harris.com
Harris Computer Systems Div.
Fort Lauderdale, Florida

Technical Details

Message-ID: <1aigthINNajm@travis.csd.harris.com>

Path:

arc1-ca.pugleaf.net!sparky!uunet!charon.amdahl.com!pacbell.com!iggy.GW.Vitalink.COM!cs.widener.edu!eff!news.byu.edu!gatech!rpi!uwm.edu!caen!uflorida!travis.csd.harris.com!ada1!joel

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!charon.amdahl.com!pacbell.com!iggy.GW.Vitalink.COM!cs.widener.edu!eff!news.byu.edu!gatech!rpi!uwm.edu!caen!uflorida!travis.csd.harris.com!ada1!joel
From: joel@ada1.ssd.csd.harris.com (Joel Horn)
Newsgroups: comp.apps.spreadsheets
Subject: Excel: using array references returned by macros
Message-ID: <1aigthINNajm@travis.csd.harris.com>
Date: 2 Oct 92 22:02:25 GMT
Distribution: na
Organization: Harris CSD, Ft. Lauderdale, FL
Lines: 12
NNTP-Posting-Host: ada1.ssd.csd.harris.com