Optimising VBA Code - For loop

[jdmc45]

I want to optimise my VBA code for a large for loop.

I am looping through each time, recalculating some data, and copying and pasting
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I think I can optimise the following code:

CurrWS.Range("fin_output").Copy
Dest.PasteSpecial xlPasteValues
Application.CutCopyMode = False

To something like:

CurrWS.Range("fin_output").Copy Destination:=OutputWS.Range("a1").Value

Which doesn’t use copy/paste with the clipboard which should save time. But it doesn’t seem to work.
<o> </o>
I have also included

<o>

<o:p></o:p>
Application.ScreenUpdating = False

</o><o> </o>
<o></o>
Which should speed up the code. Also, is there a way to not use a for loop at all in favour of some other method that is much faster?
<o> </o>
Any help is much appreciated.
<o> </o>
James

 

[jdmc45]

I am using Excel 2007

 

[jdmc45]

any help please?

 

[jdmc45]

bump

 

[GTO]

As you are only taking the values, simply assign the value of one range to the other, like:

OutputWS.Range("A1:A10").Value = CurrWS.Range("A1:A10").Value