Ok, here's the code for it
Basically it makes a loop from 1 to the value in D1, which is the total amount of clients there's in the list.
Please Login or Register to view this content.
and then starting from C23 it adds an increasing number starting from 1 to every 4th row.
Simple, but painfully slow... Is there some trick to make it faster?
The sample you gave works very quick, i don't see what your problem could be unless you are actually adding a formula then it would slow down as the worksheet will calculate for every formula added so you need to set the calulation to manual.
Not all forums are the same - seek and you shall find
Hi
What is a typical value in D1 and What is your expected and observed speed?
Ravi
Right now there's 300-400 in D1Originally Posted by ravishankar
it takes around ... 30 seconds or so.
and to Simon, nope there's no formula
it adds just a number 1, 2 ,3, 4 ,5 and so on.
Try this see if it makes a difference!
Please Login or Register to view this content.
Try this see if it makes a difference!
Please Login or Register to view this content.
Worked like charm, thanks!
Great trick!
Used
Application.Screenupdating=False
Application.Calculation = xlManual
'YOUR CODE
Application.Calculation = xlAutomatic
Application.Screenupdating=True
Adding the Application.Calculation to Manual took my run time from 5 minutes to 45 seconds.
Disabled the screen update as well & took it down to 13 seconds.
This doesn't use a loop to get the result
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks