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

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

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"
> <><><><><><><><><><><><>

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"
> > <><><><><><><><><><><><>
>

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"
> > > <><><><><><><><><><><><>
> >