| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" <<<<<<<<<<<< |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" <<<<<<<<<<<< |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" <<<<<<<<<<<< |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying Formulas to a Range in a Worksheet | Excel Discussion (Misc queries) | |||
| Bug applying Borders to Range | Excel Programming | |||
| Applying Offset to Range in VBA | Excel Worksheet Functions | |||
| Applying vlookup to a range | Excel Programming | |||
| Help with applying function to cells | Excel Programming | |||
Linear Mode
