| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating new sheet and renaming problem
Hi All,
I am trying to copy content of one sheet into another new sheet and then trying to rename that sheet but not able to do that. Also is there any way to copy the content to a specific sheet, then in that case i can probably rename a sheet and then will copy the content. Thank Rohit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating new sheet and renaming problem
Are you doing that with a code or manually?
When you say 'not able to do that' - what exactly stops you from doing that? On Jun 22, 11:21*am, Rohit wrote: Hi All, I am trying to copy content of one sheet into another new sheet and then trying to rename that sheet but not able to do that. Also is there any way to copy the content to a specific sheet, then in that case i can probably rename a sheet and then will copy the content. Thank Rohit |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating new sheet and renaming problem
On Jun 22, 5:21*am, Rohit wrote:
Hi All, I am trying to copy content of one sheet into another new sheet and then trying to rename that sheet but not able to do that. Also is there any way to copy the content to a specific sheet, then in that case i can probably rename a sheet and then will copy the content. Thank Rohit sub copyandname() sheets("shttocopy").copy after:=Sheets(Sheets.Count) activesheet.name="Rohit" end sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with renaming work sheet name | Excel Discussion (Misc queries) | |||
| Problem renaming worksheet | Excel Programming | |||
| Creating and renaming a worksheet from user input | Excel Programming | |||
| renaming problem | Excel Worksheet Functions | |||
| Problem with creating numerous shapes on a single sheet | Excel Programming | |||
Linear Mode
