R,

Instead of using the tab name, try using the worksheet's codename. Look at the sheet within the
project explorer, and look for something like

Sheet1 (Sheet1)

The value is the ()'s is the sheetname, which will change as the sheet is renamed:

Sheet1 (NewSheetName)

You can either use

Worksheets("NewSheetName").Range(.....)

or

Sheet1.Range(....)

I'm not sure if the sheet codename will change when the language changes, but it is worth a try.

HTH,
Bernie
MS Excel MVP


"RBeau" wrote in message
...
I have several macros that reference tabs in a workbook. When the file is
translated to Chinese / Korean, the tab names on the worksheets are also
translated. So when the macro references these tabs, it can't find them. I
have tried copying the Chinese / Korean and substituting into the macro, but
I can't seem to copy the characters. Is there an add-in (for double byte
characters) that I need in order to be able to copy and paste the characters
into the macro so that I can get it to work properly?

Thanks in advance for any suggestions.