Currently using this macro to save copy of sheet in same book.
What am wanting to do if possible, is take the value from cell b3, a
copy is created and use it for the new sheet name. Looked at multipl
postings and haven't been able to find something specific to this. An
help would be appreciated.

Sub SaveCopy()
'
' SaveCopy Macro
'
Sheets("Summary").Select
Sheets("Summary").Copy Befo=Sheets(1)
ActiveSheet.Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("A1").Select
Sheets("Summary").Select
End Su

--
Message posted from http://www.ExcelForum.com