Applying a function to a range

[michelle439731]

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

 

[BSc Chem Eng Rick]

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]

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

D'oh!

 

[Sam Wilson]

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

 

[michelle439731]

Works! Smashing.

Thanks Sam!

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