vba-tutorial.com
Copy Cells From One Range to Another Without Using Selections - VBA Tutorial
Copy and Paste an Excel Range without needing it selected on the worksheet. Formulas and Formatting stay intact.