 |
|
| Computers Forum Index » Computer Applications - Spreadsheets » how can I copy+paste down 332324 rows ???... |
|
Page 1 of 1 |
|
| Author |
Message |
| colwyn... |
 Posted: Wed Nov 26, 2008 11:17 pm |
|
|
|
Guest
|
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 L5,
copy L4, paste values to L4,
copy L5, paste to L6,
copy L5, paste values to L5,
.......and so on down to row 332324.
Can anyone please help me with this one ??
Big thanks.
Colwyn. |
|
|
| Back to top |
|
|
|
| spwmarluk... |
| Posted: Thu Dec 11, 2008 1:28 pm |
|
|
|
Guest
|
On 27 Lis, 00:17, colwyn <aztecwest... at (no spam) googlemail.com> wrote:
Quote: 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 L5,
copy L4, paste values to L4,
copy L5, paste to L6,
copy L5, paste values to L5,
......and so on down to row 332324.
Can anyone please help me with this one ??
Big thanks.
Colwyn.
Hi,
Primo:
There are only 65536 rows (excel, calc).
Secondo:
I think something like that can help u:
Sub my_copy()
Application.ScreenUpdating = False
Dim my_tmp As String
For i = 4 To 65535
ActiveSheet.Cells(i + 1, 12).FormulaR1C1 = ActiveSheet.Cells(i,
12).FormulaR1C1
my_tmp = ActiveSheet.Cells(i, 12).Value
ActiveSheet.Cells(i, 12).Clear
ActiveSheet.Cells(i, 12).Value = my_tmp
Next i
my_tmp = ActiveSheet.Cells(65536, 12).Value
ActiveSheet.Cells(65536, 12).Clear
ActiveSheet.Cells(65536, 12).Value = my_tmp
Application.ScreenUpdating = True
End Sub
regards - pozdro
luke |
|
|
| Back to top |
|
|
|
| spwmarluk... |
| Posted: Thu Dec 11, 2008 1:38 pm |
|
|
|
Guest
|
Quote: Primo:
There are only 65536 rows (excel, calc).
I've only oo.o3 and mso'03 ofc:) |
|
|
| Back to top |
|
|
|
| RUSS BARTOLI... |
| Posted: Fri Dec 12, 2008 2:53 am |
|
|
|
Guest
|
Use a data-table.
Then you'd only need one instance of the formula and it would operate on
multiple rows (and columns, if needed) of inputs.
"spwmarluk" <lukasz.penza at (no spam) gmail.com> wrote in message
news:dd3c7e75-01e5-4f3e-ab55-df0f95c6f31c at (no spam) t39g2000prh.googlegroups.com...
Quote: On 27 Lis, 00:17, colwyn <aztecwest... at (no spam) googlemail.com> wrote:
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 L5,
copy L4, paste values to L4,
copy L5, paste to L6,
copy L5, paste values to L5,
......and so on down to row 332324.
Can anyone please help me with this one ??
Big thanks.
Colwyn.
Hi,
Primo:
There are only 65536 rows (excel, calc).
Secondo:
I think something like that can help u:
Sub my_copy()
Application.ScreenUpdating = False
Dim my_tmp As String
For i = 4 To 65535
ActiveSheet.Cells(i + 1, 12).FormulaR1C1 = ActiveSheet.Cells(i,
12).FormulaR1C1
my_tmp = ActiveSheet.Cells(i, 12).Value
ActiveSheet.Cells(i, 12).Clear
ActiveSheet.Cells(i, 12).Value = my_tmp
Next i
my_tmp = ActiveSheet.Cells(65536, 12).Value
ActiveSheet.Cells(65536, 12).Clear
ActiveSheet.Cells(65536, 12).Value = my_tmp
Application.ScreenUpdating = True
End Sub
regards - pozdro
luke |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Thu Dec 10, 2009 10:31 am
|
|