What code for repeatedly copy, paste values ??

C

colwyn

s/s is 332324 rows deep and contains 26412 ranges.

In cell L4 is a nested formula which I want to fill this down to row
332324 and then copy+paste values F4:F332324.

Even with 2Gb RAM this is proving impossible.

What I would like to know is: is there code which will:

copy L4, paste to F5, copy F4, paste values to F4,
copy F5, paste to F6, copy F5, paste values to F5,
......and so on down to row 332324.

See attachment below.

Can anyone please help me with this one ??
Big thanks.
Colwyn.


+-------------------------------------------------------------------+
|Filename: example.xls |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=22|
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Reference and Concatenate 1
How can I cut+paste formulas+formats? 5
Copy condtional formatting in XL2007 for Windows 1
Copy Dependent On Cell Value 1
can this formula be coded? 9
code stops working after X rows. 10
how to copy and paste value from one sheet to another 4
Copy/paste in based on duplicate value in previous row 0

Top