How to retain the sheet index

[Emily]

Suppose I have made a copy of sheet 1 "Name XXX" in the same workbook and automatic named as Sheet11 "Name XXX(2)" and sheet 1 is deleted afterwards. How can I recover the index "Sheet 1" which viewed in VBA from "Sheet 11"?

 

[Emily]

Thanks All.

The code is running perfectly.

I found the error code is due to my misunderstanding between sheet name and code name, Sheet1 (Sheet1) shown in the VBA project. The error appears when I trying to rename the code name which exists.

Many^many thanks
Emily

 

[Jack in the UK]

Hi Emily it Jack

I have seen a few of your post re errors in Chineese XP and Win 98ME

"am using Window Me and Chinese Office XP. "

Can i ask what version of Me you are running?

This i feel will account for much of your errors you post about

Also i haveWin 95 and Win98 and Office 97 in Chineese [Cantaneese} so im more that willing for you to send over the work book for me to look at ??

Also can i ask did you install Chineese XP over old version of Office??

Many thanks i will try to help best i can, if its easier you can post in Cantonise i can just about read OK, as well as i can English, but most of my friends are from Hong Kong.

Where abouts are you??

 

[Jack in the UK]

OK as its out i did post to offer help but we all know you ant chineee and dont use chineese XP, thus i thought as i posted.

How ever all i have said is true, ho hum!!

See Whats Jacks name !!! sould be fun any rate!

 

[Emily]

Thanks Jack.

Sometimes I cannot express the correct Office term in English due to I am using Chinese Win ME and Office XP (Traditional Version). But I think most of this board cannot understand Chinese, right?

May be, you can give help to the forum below
http://www.excelhelp.net/cgi-bin/forum/leoboard.cgi

Thanks

 

[Ivan F Moala]

On 2002-09-15 19:57, Emily wrote:
Thanks Jack.

Sometimes I cannot express the correct Office term in English due to I am using Chinese Win ME and Office XP (Traditional Version). But I think most of this board cannot understand Chinese, right?

May be, you can give help to the forum below
http://www.excelhelp.net/cgi-bin/forum/leoboard.cgi

Thanks

Goto;
http://babelfish.altavista.com/tr

And Type URL >

http://www.excelhelp.net/cgi-bin/forum/leoboard.cgi

> Select Chinese To English

To get Translation......still a little hard to understand.....would like to help out.

 

[Emily]

On 2002-09-15 22:54, Ivan F Moala wrote:
Goto;
http://babelfish.altavista.com/tr

And Type URL >

http://www.excelhelp.net/cgi-bin/forum/leoboard.cgi

> Select Chinese To English

To get Translation......still a little hard to understand.....would like to help out.

Remark: I got a mess in that translation.

You mean the forum content.
There is pop up screen for non-resgister user, it will disppear in 5 seconds.
There are several section, the upper section is mainly knowledge for excel divided into beginner, intermediate and advance.
Next section is discussion, one is for function and the other one is for VBA.
The last section is for misc.

forum without VBA is :
http://www.excelhelp.net/cgi-bin/forum/forums.cgi?forum=4

For VBA is:
http://www.excelhelp.net/cgi-bin/forum/forums.cgi?forum=8

moderator Carson, carson@excelhelp.net