limitation of Selection.Copy

[alfredjp]

what would be a better way to copy TONS of data from one excel workbook to another excel workbook?

what ive done was to use Cells.Select to "define" an entire range of data, and use Selection.Copy, then i transfer to the second workbook and use .Paste... unfortunately, it somehow fails when there is TOO much data...

on a more technical note, does Selection.Copy utilize the OS' clipboard (which of course has a limitation of 64K), or does it use something else? is there a limit of the size that "Selection.Copy" can copy?

=alfred

 

[acron]

As Cells.Select selects the entire worksheet, you might as well use something like

Sheets("SheetToCopy&quot.Copy _
Before:=Workbooks("DestinationBook&quot.Sheets(1)
ActiveSheet.Name = "CopiedSheet"

A.C.

 

[xlbo]

Acron is right if you want to copy the whole sheet
If you have a set range to copy, don't bother selecting them. Use this syntax

With sheets("DataFrom&quot.range("CopyRange&quot
.copy detination:= sheets("SheetsTo&quot.Range("CopyToRange&quot
end with

This does away with select copy paste and is MUCH quicker and more stable Rgds
~Geoff~

 

[xlbo]

typo - should be destination Rgds
~Geoff~

 

[alfredjp]

thanks for all the replies... now i know how to implement what i need...
as expected... with VB/VBA so wide in scope, one just cannot but avoid gaps in their knowledge...