Copying and pasting rows

[Blaster]

I have a sheet in excel with formulas, after some time I would like to transform some rows in values. Can anyone help me?

Eg:

row 1:1 copy and paste values,
then 5 min after,
row 2:2 copy and paste values,
.
.
.
then 5 min after,
row 1000:1000 copy and paste values

thank you

[stanleydgromjr]

Blaster,

Try:

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

Insert a Module in your VBAProject, Microsoft Excel Objects

Copy the below code, and paste it into the Module1.

Please Login or Register  to view this content.

Then run the "Test" macro.


Have a great day,
Stan

[Blaster]

Hi,

It worked, but I wanted to copy and paste all the rows between 1 and 1000, and not only the three rows that I said. Thank you again.

[SOS]

Hi Blaster,

What about

Please Login or Register  to view this content.

[Blaster]

That code works almost perfectly. But it freezes the excel between each copy and paste.

I searched in the forum and found a site with an example with I tried to use.

Please Login or Register  to view this content.

But this code also freezed the excel. Is there a way to run the macro without freezing?

Thx