View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anand Nichkaode Anand Nichkaode is offline
external usenet poster
 
Posts: 53
Default Multi-lingual characters

Hi,

I have one Excel workbook, where one of the sheet names have some
multilingual characters. When I try to select this sheet with following code
it fails saying "Subscript out of range"

Set objSheet = RptObj.Worksheets("aeiüûúñðþß½¶º»µ®¡ ¢¤¥¦")

objSheet is a worksheet object, RptOjb is a workbook object and
"aeiüûúñðþß½¶º»µ®¡¢¤¥¦" is the sheet name (first and last double quotes are
not part of the sheet name)

Anybody have any idea how to make it work.

Any information will be appreciated.

Thanks in advance.