Do you need to write a macro that copies worksheets from one workbook to another, or even within the same workbook? If so, you need to become familiar with the Copy method, described in this tip. There are wide number of ways you can use the method to perform a copy just as you want. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Copying Worksheets in a Macro Microsoft Excel Tips - Master Excel's Power!
