problem evaluating custom functions

  • Thread starter Thread starter Radu Margarint
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify working code to expand the output. 5
CSE with function returning an array? 2
custom function - finding cell address 4
lastrow function help 6
VBA Countif across sheets? 5
Excel Typed text appears in wrong cell 0
Excel Function not Evaluating to a Result 1
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top