Hi all!!
I've created a macro which works great within worksheet now, I would like to clean up the trail of sheets it leaves behind i.e. three. So I thought, copy the data I need then ask it to delete the sheet before it creates a new one:
Range("A:B").SpecialCells(xlCellTypeVisible).Copy
ActiveWindow.SelectedSheets.Delete
Sheets.Add
ActiveSheet.Paste
It asks me whether I really want to Delet to which I click yes (is there a way for this pop-up not to appear?) then, I get a Run Time Error '1004', any ideas??
Many thanks,
Phil