Moving (Selected) sheets to a new Workbook
Posted by J.Hardwicke on March 23, 2000 4:28 AM
Is there a way in selecting WorkSheets and moving them across to a new Workbook then be given the choice of filename and directory to save it in.
The snag is that the Workbook containing the Sheets can varry from amount of Sheets and Names of Tabs. However all of these can be moved except 2 static named Sheets e.g. "Main" & "Data"
Can someone out there please help. (Stuck with arrays etc).