| Home |
| Search |
| Today's Posts |
|
#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" <<<<<<<<<<<< |
| 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 | |||
Threaded Mode
