You could turn calculation off, but without actually having the workbook it's
hard to know what else is going on. It shouldn't be any slower in code than
without code, so something is certainly happening. Feel free to email me the
wb --
(E-Mail Removed), and explain the issue. Use subject of "AllExpertsQ"
"(E-Mail Removed)" wrote:
> I tried disabling and enabling events and it was the same speed. Do you
> think this might have to do with the user defined functions I have running?
> Any other ideas?
>
> Thanks
>
> Adam Bush
>
> "Bob Umlas, Excel MVP" wrote:
>
> > See if you have worksheet_change event code which may be running in a loop
> > because when you put in the time, you're changing the worksheet and this can
> > cause the event code to run again. If that's the case, precede the entry of
> > the time with
> > Application.EnableEvents = False
> > and turn it to true afterwards.
> > HTH
> > Bob Umlas
> >
> > "(E-Mail Removed)" wrote:
> >
> > > I have a macro that grabs the current time from a website and then brings it
> > > into my worksheet. I put manual calculation on when I run this and it takes
> > > less than a second. However, when I put the sheet back on auto calc, it
> > > takes 53 seconds to recalculate. If i actually go into the worksheet, put it
> > > on manual, type in the new time, and then put it back on auto it only takes 5
> > > seconds to recalc. Any reason why there would be such a discrepency? I have
> > > several user defined functions in the workbook, but they are being used by
> > > either form of recalculation. Any help would be greatly appreciated.
> > >
> > > Thanks
> > >
> > > Adam Bush
Similar Threads
