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