problem evaluating custom functions
 

Hello everyone,

I have a small problem. I have a small VBA function which accepts one cell
as input (let's call it cell A), uses a number of other predefined cells
(cell B,C), and returns a result. If I code the behavior directly into the
cell's field using building in functions instead of my own function, when I
update cell B and C the result cell autoupdates. However, if I use my own
custom function, if I update cell B,C, the result cell doesn't update until
I do something to do. Given there are a LOT of result cells, it's not
practical to have to touch every cell just update it's result. Is there a
way I can force it to recalculate all cells?

Thanks
Radu

problem evaluating custom functions
 

Hi
see your postin in excel.worksheetfunctions

--
Regards
Frank Kabel
Frankfurt, Germany

"Radu Margarint" schrieb im Newsbeitrag
...
Hello everyone,

I have a small problem. I have a small VBA function which accepts one
cell
as input (let's call it cell A), uses a number of other predefined
cells
(cell B,C), and returns a result. If I code the behavior directly
into the
cell's field using building in functions instead of my own function,
when I
update cell B and C the result cell autoupdates. However, if I use my
own
custom function, if I update cell B,C, the result cell doesn't update
until
I do something to do. Given there are a LOT of result cells, it's not
practical to have to touch every cell just update it's result. Is
there a
way I can force it to recalculate all cells?

Thanks
Radu