PC Review


Reply
Thread Tools Rate Thread

Creating new sheet and renaming problem

 
 
Rohit
Guest
Posts: n/a
 
      22nd Jun 2010
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
 
Reply With Quote
 
 
 
 
AB
Guest
Posts: n/a
 
      22nd Jun 2010
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 <rohitesh4...@gmail.com> 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


 
Reply With Quote
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      22nd Jun 2010
On Jun 22, 5:21*am, Rohit <rohitesh4...@gmail.com> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with renaming work sheet name D Moonn Microsoft Excel Misc 1 19th Apr 2009 12:21 PM
Excel Macros: Creating, positioning and renaming a sheet john.galt.online@gmail.com Microsoft Excel Discussion 2 26th Jun 2007 02:16 PM
Problem creating/renaming network folders Tim Windows Vista General Discussion 2 7th Oct 2006 02:41 PM
Renaming Sheet Problem Funky Junky Microsoft Excel Misc 1 26th Aug 2004 11:04 PM
Renaming worksheet tabs; linking a result on 1 sheet to a 2nd sheet. djm Microsoft Excel Misc 0 16th Mar 2004 03:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:26 AM.