Copy block of cells using R1C1 reference in Excel

  Desert Andy 12:32 29 Aug 10
Locked

Hi

I want to copy a table fom one worksheet to another using R1C1 reference.

So if I wanted to Copy range "A1:C20", how could i refer to this in R1C1 annotation. Is it possible?

Thanks

  VoG II 12:42 29 Aug 10

Using Cells notation

With Sheets("Sheet2")
.Range(.Cells(1, 1), .Cells(20, 3)).Copy Destination:=Sheets("Sheet3").Cells(1, 1)
End With

  Desert Andy 13:15 29 Aug 10

thanks

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced