Re: $$Excel-Macros$$ Slow down time in Processing Information *

2012-12-13 Thread Divaker Pandey
use both code and keep your current code between them On Thu, Dec 13, 2012 at 9:44 PM, Hilary Lomotey wrote: > thanks chief , but which of the codes shd i use, you provided two > > On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > >> [image: Boxbe] This m

Re: $$Excel-Macros$$ Slow down time in Processing Information *

2012-12-13 Thread Hilary Lomotey
Chief, its work beautifully, you are great thanks On Thu, Dec 13, 2012 at 4:14 PM, Hilary Lomotey wrote: > thanks chief , but which of the codes shd i use, you provided two > > On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > >> [image: Boxbe] This messa

Re: $$Excel-Macros$$ Slow down time in Processing Information *

2012-12-13 Thread Hilary Lomotey
thanks chief , but which of the codes shd i use, you provided two On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (divake...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Slow down time in Processing Information

2012-12-13 Thread Divaker Pandey
hi you can write some code on command button click with application .screenupdating=false .calculation= xlcaluationmanual end with -Prsent code-- with application .screenupdating=true .calculation= xlcaluationautomatic end with On Thu, Dec 13, 2012 at 9:16 PM, Hilary Lomo

$$Excel-Macros$$ Slow down time in Processing Information

2012-12-13 Thread Hilary Lomotey
Hello When i click on a command button on my userform, it takes close to 50 secs before the information is processed to the worksheet. what could be accounting for this. is there a way to minimize the time?. thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discusse