Copy block of cells using R1C1 reference in Excel

  Desert Andy 12:32 29 Aug 2010
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 2010

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 2010

thanks

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

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique