How can a calculate fire a Change event. Are there DDE links?

More likely a change event fires a calculate.

--
Regards,
Tom Ogilvy

"Charlie" <Charlie@discussions.microsoft.com> wrote in message
news:6E85DE22-603E-46FA-BB29-D706754CFB67@microsoft.com...
> Are saying you want all sheet calculations to complete first, then the
> Worksheet_Change event to fire last? (But the calculations are firing it
> prematurely?) Yea? Nay?
>
> Maybe you can re-fire the Worksheet_Change event after the
> Application.EnableEvents = True statement. I don't know how to do that.
> Tom? Jim? Chip?
>
> Or you may need to rewrite your logic to move or duplicate what it is you
> are doing in the Worksheet_Change sub to your main code.
>
> That's about all I can think of.
>
> "Kris" wrote:
>
> > Charlie wrote:
> > > Maybe try
> > >
> > > Application.EnableEvents = False
> > > Application.Calculate
> > > Application.EnableEvents = True
> > >
> >
> > No.
> > I doesn't work. Still the same.
> >
> >
> >