Hi All,
I need to make a copy of a template sheet, containing a chart area, which in
turn contains a plot area.
I create a new sheet, rename it, then copy contents of a template as
follows -
Sheets(TemplateSheet).Activate
ActiveSheet.UsedRange.Select
Selection.Copy
With ActiveWorkbook.Sheets
.Add After:=Worksheets(Worksheets.count)
End With
NewSheetName = "newname"
ActiveSheet.Name = NewSheetName
ActiveSheet.Paste
It copies all the spreadsheet, but no plot shows up on a copy.
How can I do that?
Thanks!
Bookmarks