Copy Method Example

This example copies cell C3 to cell G5 on the active worksheet.

Set sht = Spreadsheet1.ActiveSheet
sht.Range("c3").Copy sht.Range("g5")