There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA