Hi Clara,

Are you sure that you are allowing for
initial or trailing spaces i.e, that the
spelling is *identical*?

Using my UK English version, I had no
problem with:

'==========
Public Sub TestIt()
Dim SH As Worksheet

ActiveSheet.Name = "Bâtir Français"

Set SH = ThisWorkbook.Sheets("Bâtir Français")

MsgBox SH.Index

End Sub
'<<==========




---
Regards.
Norman


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

I have a sheet named "Bâtir Français", but when I refer to sheets("Bâtir
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