Copying and pasting rows

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

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

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.