Copy an entire range

[Mircea Pleteriu]

Hi,

How to copy a range from one Excel document to another.
I know the coordonates within the destination document where the range has
to be copied from the source document.

Thanks a lot,
Mircea

 

[Bob Phillips]

Do you mean something as simple as

Workbooks("Book1").Worksheets("Sheet2").Range("A1:H100").Copy _
Destination:=Workbooks("Book2").Worksheets("Sheet1").Range("A1")


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Mircea Pleteriu]

It fails with the error message:

"Copy method of Range class failed."

My code is C# code.

 

[Bob Phillips]

Well that is VBA, you will need to adapt, I don't do C#

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Mircea Pleteriu]

thanks,

Well that is VBA, you will need to adapt, I don't do C#

--

HTH

RP
(remove nothere from the email address if mailing direct)