| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which inserts new sheet name
Hi, I have a macro where I need to paste the content of a copied cell
as the sheets name. Below is example of where I am, but can't find the syntax to paste the copied value when re-naming the sheet. Any suggestions would be really appreciated.... thanks Bev Sub selectandcopy() Cells.Select Selection.Copy Sheets.Add ActiveSheet.Paste Range("E2").Select Application.CutCopyMode = False Selection.Copy ActiveSheet.Select ActiveSheet.Name = *****Paste copied selection from E2 here" Sheets("Sheet2").Select End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recorded single column insert in macro. Macro inserts two not one | Excel Programming | |||
| Macro inserts a column but dont update formulas in another sheet! | Excel Programming | |||
| Excel automatically inserts a formula in my sheet | Excel Worksheet Functions | |||
| Macro that inserts lines reply | Excel Discussion (Misc queries) | |||
| Macro that inserts lines | Excel Discussion (Misc queries) | |||
Threaded Mode
