Quicker way to loop through WorksheetFunction?

[newbi004]

Hi

I have the following code that loops through data to check what mileage each vehicle has done between "Current Month" and "Last Month".

The code uses WorksheetFunction.Vlookup to compare vehicle registrations for current & last months and their corresponding mileage readings.

Finally, the mileage readings difference between current month and last month is placed in column 12 of current month to give the mileage done in current month.

The code works fine but takes about 7 seconds to complete its trawl through about 300 rows of data.

As the list is likely to increase in future, I was wondering if there is a quicker way to loop?

Any advice would be greatly appreciated.

Thanks

Please Login or Register  to view this content.

[OllieB]

Any chance of posting a copy of your workbook?

[newbi004]

Sorry about the delay. A sample is attached

[newbi004]

Any thoughts?

[OllieB]

I was in a meeting at work. Will have a look

[OllieB]

Please try

Please Login or Register  to view this content.

[OllieB]

or, using a different approach

Please Login or Register  to view this content.

[newbi004]

Wow! A completely new approach, OllieB

I will try this out and let you know how I get on.

Many thanks for taking the time to help