It all depends on what you are trying to do..


Why do you need nested loop's? (I cant see any reason for it in your code)

Is there a need for PasteSpecial (as opposed to just a paste)? If not, we can speed that up a lot.

How are your variables declared?



It's probably best to explain what you want the code to do, and show us the code you have.