Hi, if I manually or programmatically paste data into 2+ cells with user
defined functions only the first cell's function is executed. Is there some
sort of equivalent to Calculate or some other way to force this? I have
found that if I manually cut the formula from the cell and paste it back
into the same cell, it executes, but that seems hacky and burdensome.

Thanks,
Mike

Make your first line in the UDF

Application.Volatile

This will for the UDF to recalucate with each calculation of the sheet.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Hi, if I manually or programmatically paste data into 2+ cells with user
defined functions only the first cell's function is executed. Is there some
sort of equivalent to Calculate or some other way to force this? I have
found that if I manually cut the formula from the cell and paste it back
into the same cell, it executes, but that seems hacky and burdensome.

Thanks,
Mike

Thank you Jim. I tried that, but have some sort of concurrency/infinite loop
issues remaining. Are their known problems with putting UDFs in the
worksheet_change event?
"Jim Thomlinson" wrote in
message ...
Make your first line in the UDF

Application.Volatile

This will for the UDF to recalucate with each calculation of the sheet.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Hi, if I manually or programmatically paste data into 2+ cells with user
defined functions only the first cell's function is executed. Is there
some
sort of equivalent to Calculate or some other way to force this? I have
found that if I manually cut the formula from the cell and paste it back
into the same cell, it executes, but that seems hacky and burdensome.

Thanks,
Mike

Hi,

I faced the same problem that deleting / pasting cell in Excel will fire the
Calculate event to execute again & again (infinite loop)...

Is it a known bug of UDF and Calculate event?

Thanks,
Peter

"me" wrote:

Thank you Jim. I tried that, but have some sort of concurrency/infinite loop
issues remaining. Are their known problems with putting UDFs in the
worksheet_change event?
"Jim Thomlinson" wrote in
message ...
Make your first line in the UDF

Application.Volatile

This will for the UDF to recalucate with each calculation of the sheet.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Hi, if I manually or programmatically paste data into 2+ cells with user
defined functions only the first cell's function is executed. Is there
some
sort of equivalent to Calculate or some other way to force this? I have
found that if I manually cut the formula from the cell and paste it back
into the same cell, it executes, but that seems hacky and burdensome.

Thanks,
Mike