VB - Need to optimise/alternative to copy and paste

Hi Everyone,

I am a noob at vb so sorry if i do something stupid.

I am trying to auto fill a report from a log file by importing the csv file and rearranging the data.

There is lots of copy and pastes in two loops which works in debugging but is takes ages and is prone to crashing. (20 minutes to run)

Can anyone give me ideas to speed up the process.

I already have screen update and calculations update to False and manual.

Thanks in Advance.

The problem code is below:

Please Login or Register  to view this content.

Maybe you can attach the file that contains the macro so its easy to test it and find the problem areas.

Ahhh,

That is a much better way of doing things, I didn't realize how slow the activating and selecting was.

That decreased it from 20 minutes to 1 minute.

There was an extra comma in there so the code is :

Please Login or Register  to view this content.

I have to admit, i had to go through that line about 10 times to trace exactly where it was going!!

I have changed the code in other areas to not use so much select and activate.

I will attach the files next time, sorry if it was an inconvenience.

Thanks heaps Andrew for your help, I really appreciate it.

Happy to have helped, and sorry for the extra comma.

The important things are that so long as you have two ranges the same size you can just assign values from one to the other, e.g.

Please Login or Register  to view this content.

If you want formatting, colours and so forth, as well as values, you can go with:

Please Login or Register  to view this content.

No need for activating and selecting all over the place, which, as you've found out, really slows things down.