Applying a function to a range
 

Hello,

I would like to apply a user defined function to a range of data. The
output from the function is an array of the same size as the original matrix.
I want to then compare this matrix to the original.

Any help would be greatly appreciated.

Thank you very much,

Michelle

Applying a function to a range
 

Before you enter the formula make sure the correct size "answer" range is
selected. Enter your formula in the top-left of this range and the hit
Ctrl+Shift+Enter (for array formulas)

If this helps please click "Yes"
<<<<<<<<<<<<

"michelle439731" wrote:

Hello,

I would like to apply a user defined function to a range of data. The
output from the function is an array of the same size as the original matrix.
I want to then compare this matrix to the original.

Any help would be greatly appreciated.

Thank you very much,

Michelle

Applying a function to a range
 

Oh nuts! I'm very sorry, I didn't say in my original post. I'm trying to do
this in VBA.

D'oh!

"BSc Chem Eng Rick" wrote:

Before you enter the formula make sure the correct size "answer" range is
selected. Enter your formula in the top-left of this range and the hit
Ctrl+Shift+Enter (for array formulas)

If this helps please click "Yes"
<<<<<<<<<<<<

Applying a function to a range
 

dim rngAnswer as range
rngAnswer.formulaarray = "=UDF(A1:B3)"



"michelle439731" wrote:

Oh nuts! I'm very sorry, I didn't say in my original post. I'm trying to do
this in VBA.

D'oh!

"BSc Chem Eng Rick" wrote:

Before you enter the formula make sure the correct size "answer" range is
selected. Enter your formula in the top-left of this range and the hit
Ctrl+Shift+Enter (for array formulas)

If this helps please click "Yes"
<<<<<<<<<<<<

Applying a function to a range
 

Works! Smashing.

Thanks Sam!

"Sam Wilson" wrote:

dim rngAnswer as range
rngAnswer.formulaarray = "=UDF(A1:B3)"



"michelle439731" wrote:

Oh nuts! I'm very sorry, I didn't say in my original post. I'm trying to do
this in VBA.

D'oh!

"BSc Chem Eng Rick" wrote:

Before you enter the formula make sure the correct size "answer" range is
selected. Enter your formula in the top-left of this range and the hit
Ctrl+Shift+Enter (for array formulas)

If this helps please click "Yes"
<<<<<<<<<<<<