Discussion:
how can I copy+paste down 332324 rows ???
(too old to reply)
colwyn
2008-11-26 23:17:01 UTC
Permalink
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.
spwmarluk
2008-12-11 13:28:15 UTC
Permalink
Post by 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.
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
spwmarluk
2008-12-11 13:38:25 UTC
Permalink
Post by spwmarluk
There are only 65536 rows (excel, calc).
I've only oo.o3 and mso'03 ofc:)
RUSS BARTOLI
2008-12-11 20:53:03 UTC
Permalink
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.
Post by spwmarluk
Post by 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.
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,
There are only 65536 rows (excel, calc).
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
Loading...