| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What code for repeatedly copy, paste values ??
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| +-------------------------------------------------------------------+ -- colwyn ------------------------------------------------------------------------ colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34448 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a range of cells repeatedly | Excel Worksheet Functions | |||
| VBA code to copy and paste by values from one Excel workbook to another | Excel Programming | |||
| Macro - Copy and Paste repeatedly skipping cells | Excel Discussion (Misc queries) | |||
| code to FIND value, copy, paste values onto other sheet | Excel Programming | |||
| Paste data repeatedly from different worksheets to a template | Excel Worksheet Functions | |||
![colwyn[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
