Hi again (Last question, I promise....maybe)
I am currently have a macro which opens a new workbook and puts in sheets depending on certain conditions, using the code below:
Application.SheetsInNewWorkbook = 1
Set Newbook = Workbooks.Add
With Newbook
.SaveAs...