It works fine for me with a sheet with your name with my English setup.

Worksheets(1).Name = "Btir Français"
MsgBox Sheets("Btir Français").Name ' works

Are you sure you've got the name right, try this

Dim objSht as Object
For Each objSht In Sheets
Debug.Print objSht.Name
Next

Regards,
Peter T


"clara" wrote in message
...
Hi all,

I have a sheet named "Btir Français", but when I refer to sheets("Btir
Français"), then I get subscription is out of range, it can not find the
sheet, even I use the same French letters

clara
--
thank you so much for your help