cleaning up recorded VBA

can anyone help me clean this up... it is very slow, takes up to a minute or longer.

Please Login or Register  to view this content.

i actually have about 10 more pieces of code similiar to this, so im hoping i can fix the others from this one.
Im horrible at VBA so any help is greatly appeciated

The problem is all of the selections.

Select slows code down a lot.

Without knowing how you are determining what to select, nobody can really help you, sorry.



However, on a helpful note, instead of doing things like

Range("A1").Select
Selection.ClearContents

Simply use:
Range("A1").ClearContents

Basically, name the range you are applying whatever function you desire, and do that function directly, instead of first selecting then applying that function to the selection.

Apply the same logic when cleaning your code up, it will speed it up exponentially. If you require help further than that, try explaining how you are determining the selections.

Something else that helps with larger pieces of code, is to turn screen updating, automatic calculations, etc. off prior to executing the code, then turning those things back on after.

ty for the help Then... these are all pastes, so i would

Please Login or Register  to view this content.

like this?

Range("A1").Paste

i tried this with no success

Please Login or Register  to view this content.

this took it down to a bit under 4 minutes... still slow but better