Hello All,
Basically I'm trying to make a summary sheet, with the current date, and then hide.
I have:
the code copying onto a new sheet, but it is not renaming it and not hiding it.
Can someone tell me what I'm doing wrong please.
Thanks
Basically I'm trying to make a summary sheet, with the current date, and then hide.
I have:
VBA Code:
Set ECD = Sheets("ECD")
ECD.Select
Range("A1:AI3000").Copy
Sheets.Add After:=ECD
With ActiveSheet
.Paste
.Name = Format(Date, "DD-MM-YYYY")
ActiveWindow.SelectedSheets.Visible = False
End With
the code copying onto a new sheet, but it is not renaming it and not hiding it.
Can someone tell me what I'm doing wrong please.
Thanks