Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Value as String as Worksheet Name
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert worksheet string name to date format in cell | Excel Worksheet Functions | |||
String error on closing worksheet | Excel Discussion (Misc queries) | |||
Formatting a pivot worksheet to display a string at the end! | Charts and Charting in Excel | |||
building a text string while looping though a worksheet | Excel Programming | |||
Create a formula into a String then assign string to a cell | Excel Programming |