French Words used as index

[clara]

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

 

[Peter T]

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

Worksheets(1).Name = "Bâtir Français"
MsgBox Sheets("Bâtir 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

 

[Norman Jones]

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
'<<==========

 

[Norman Jones]

Hi Peter,

Sorry! I could not see your reponse when
I penned my own!