Office VBA Reference Excel VBA Range. Copy Method (Excel). Range. Copy Method (Excel). Table of contents +. Introduction to Excel VBA. This example to show you how to copy data from one Range to another using Excel VBA. This is one of the frequently used codes in the VBA, we often do this. Learn 3 different ways to copy and paste cells or ranges in Excel with VBA Macros. 3-part video tutorial series. Download the file with VBA code.