I am trying to create a clean generic macro to copy selected sheets to a new workbook and then paste those sheets as values.
I have done this for the active sheet, but cannot seem to find the terminology to copy all of the selected worksheets (grouped) without using the worksheet names (making it workbook specific).
Any suggestions very gratefully received
Sub DTPRider() ActiveSheet.Copy Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Worksheets(1).Activate Range("B1").Select End Sub
Thanks in advance,