changing cells from function

A

Alex Colomb

I'd like to be able to call a funciton from a cell that
populates other cells within the same sheet. I know this
isn't possible as user defined functions can't return
values to cells other than the one its used it, but I've
seen it done in certain addins (bloomber's BLPH function).
Do these addins do something special that normal VBA users
don't have access to?

I'm using VBA to make a soap call that returns an array of
data. I'd like then populate certain cells within the
worksheet with that data. Any ideas on how to do this
without using a macro? Thanks.
 
B

Bill Renaud

(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.
 
B

Bill Renaud

(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.

(2nd post. First one was deleted by the server for some reason.)
 
B

Bill Renaud

(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.

(2nd post. 1st one lost by the server.)
 
B

Bill Renaud

(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.
 
Top