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

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

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