Large VBA Loop - Sometimes crashes!

[Exodus_NZ]

Hi guys

I have a large loop (10000) worth - and this is sometimes crashing and the time it does work takes forever! (My computer is pretty good)

Here is the code -

Wondering if anyone had a better way to preform the task?

Thanks inadvance

Please Login or Register  to view this content.

[tim201110]

Please Login or Register  to view this content.

[leelnich]

Perhaps:

Please Login or Register  to view this content.

The paste to Column C includes formulas AND formats. The remaining columns get values only.
You can copy, paste, or assign values to cells directly (without selecting them). It's faster.

[Exodus_NZ]

Hi

Sorry tim that didnt work ! it was really fast but didnt calculate the formulas

Thanks leelnich, same as above, doesnt seem to of copied the formulas?

[bakerman2]

If I understand correctly.

Please Login or Register  to view this content.

[leelnich]

Your sample code pastes formulas from an 18-cell section of the first column into the second column (Offset(0,1)), but it only pastes the returned values from those 18 cells (Paste:=xlPasteValues) into the rest of the columns. Is this your intention, or do you wish to copy the formulas to ALL columns?