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