Applying a function to a range

  • Thread starter Thread starter michelle439731
  • Start date Start date
M

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
 
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"
<><><><><><><><><><><><>
 
Oh nuts! I'm very sorry, I didn't say in my original post. I'm trying to do
this in VBA.

D'oh!
 
Back
Top