
6th February 2012, 07:21 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
What do you use to get the race times in order and where do you get them?
I was having a look at your last sheet the screen updating is doing twice the work, have it set like this
Application.ScreenUpdating = False
Rest of macro here
Application.ScreenUpdating = True
What that does is stops the screen updating so it just looks like the info appears and you don't see the macro working, if you do the same for the clean up macro will look smother.all the
|