Optimize a slow code...

[benoitly]

Hi guys, I am new to VBA, I have done a code that does the following :
get me all the speed variations and classify each of them to create a sort of histogram.

Since a am pretty new to VBA, and to coding in general, my code is big and slow.
If anyone could give me some nice pointer on how to optimize it will be very appreciated!
(I got like 9817398172 for loops....)

The code do this sequence :
get the time and speed difference
get the variation on these datas.
find create duplicate of the datas if its on the same slope
delete the duplicates
find variation that has a difference of speed too small depending on the users input
classify each data depending on histogram resolution
End

Please Login or Register  to view this content.

edit :
here is a piece of sample data:

Please Login or Register  to view this content.

[benoitly]

bump!!!!!!!!!!!1