calculate now for user defined functions?

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" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
> > 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
> >>
> >>
> >>
>
>
>