Excel: using array references returned by macros

Thread View: comp.apps.spreadsheets

1 messages

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

1 total messages Started by Joel Horn Fri, 02 Oct 1992 22:02

#177

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

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