Excel crashes when pasting function to range

[Budafok]

Hi Geeks,
I'm new at VBA so need Your help.

Have a code with copy function from a cell and pasting it to (more than 10.000) rows with this format:

Range("f2").Copy Range("f3:f" & lrsmseg)
Range("i2").Copy Range("i3:i" & lrsmseg)
Range("j2").Copy Range("j3:j" & lrsmseg)
Range("k2").Copy Range("k3:k" & lrsmseg)
Range("l2").Copy Range("l3:l" & lrsmseg)
Range("m2").Copy Range("m3:m" & lrsmseg)
Range("n2").Copy Range("n3:n" & lrsmseg)
Range("o2").Copy Range("o3:o" & lrsmseg)
Range("r2").Copy Range("r3:r" & lrsmseg)

where lrsmseg is the number of the last row on sheet. (most commonly between 40k and 50k)

Using this method excel crashes.
But file is well made and saved to the directory...
Shall I 'wait' between the lines???

If I use for next cycle it is ok but very very very slow!


Any idea is appreciated!

Thanks in advance,
Peter

[Artik]

Try:

Please Login or Register  to view this content.

Artik

[jolivanes]

Another possibility.

Please Login or Register  to view this content.

[jolivanes]

Don't know which of the suggestions is fastest but would be nice to find out.
This might be slightly slower.

Please Login or Register  to view this content.

[jolivanes]

You're not going to run short of trying different ways without crashing Excel.

Please Login or Register  to view this content.

[Budafok]

Dear Artik,
Dear Jolivanes,

Thanks for your replies and for wasting time with my problem! This is very kind!
Unfortunatelly these methods gave the same result. The report is ready, not faster, and at the end excel crashes.

I thought the problem is somewhere else, probably with the computer...

Anyway, thank You for all!

Regards,
Peter

[Artik]

In that case, try to clean up your project using the VBADecompiler tool.

Artik

[TMS]

What is/are the function/s you are copying? What does the rest of the code look like?


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Note: representative sample, NOT 40k-50k rows.

[jolivanes]

Just to make sure, I timed the results.
The times for the three macros in Posts 3, 4 and five for 50,000 cells are 0.25 sec, 1.9 sec and 0.16 sec and no crashes so the problem must be from somewhere else.

[jolivanes]

Just to help other people that might encounter the same or similar problem.
How did you, if you indeed did, solve the problem of crashing?