I will like to have a vb code that will allow me to select a few sheets in oneworkbook and copy them to a new workbook.
Using the .Copy method without an argument will open a new workbook andput the sheets in it. For instance, this code copies two sheets from theopen workbook into a new one:Sheets(Array("Sheet1", "Sheet3")).Copy