HiI 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
Using Cells notationWith Sheets("Sheet2") .Range(.Cells(1, 1), .Cells(20, 3)).Copy Destination:=Sheets("Sheet3").Cells(1, 1)End With
This thread is now locked and can not be replied to.
OnePlus 5 review
See the work of famous artists playing with toys
iPad Pro 10.5in (2017) review
Comment faire une capture d’écran sur un Mac ?
© Copyright 2017 IDG UK. All Rights Reserved.