R
Radu Margarint
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
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