Excel 2003 VBA: Move a sheet into a new workbook that is referenced by a variable - Stack Overflow

Although this is old, and the accepted answer by soldieraman is very nice, just wanted to add one thing. The Excel VBA Sheets.Copy and Sheets.Move methods have a very nice feature. They take either of two optional arguments, "Before" or "After", to positi

stackoverflow.com