parscon
04-04-2012, 10:33 AM
I have a Problem , Currently I have about 800000 Row
now i use this VBA code to copy data from column G to Column A
but just copy 65536 data . how can i copy all of them that mean all data on column G to Column A ?
With Sheets("Sheet1")
.Range(.Range("G1"), .Range("G65536").End(xlUp)).Copy
End With
Sheets("Sheet1").[A65536].End(xlUp)(1).PasteSpecial Paste:=xlValues
now i use this VBA code to copy data from column G to Column A
but just copy 65536 data . how can i copy all of them that mean all data on column G to Column A ?
With Sheets("Sheet1")
.Range(.Range("G1"), .Range("G65536").End(xlUp)).Copy
End With
Sheets("Sheet1").[A65536].End(xlUp)(1).PasteSpecial Paste:=xlValues