Identify specific worksheets based on name vba

[sofas]

Hello, I would like to implement a specific code on worksheets within my workbook, provided that the name of the sheet contains only two letters and ignore the rest.

For i = 2 To Sheets.Count
    nf = Sheets(i).Name
    ws.Hyperlinks.Add Anchor:=ws.Cells(i + 2, 10), Address:="", SubAddress:="'" & _
    nf & "'" & "!A1", TextToDisplay:=nf
  Next i

 

[myall_blues]

Is this what you mean?

For i = 2 To Sheets.Count
    nf = Sheets(i).Name
    if Len(nf)=2 then
        ws.Hyperlinks.Add Anchor:=ws.Cells(i + 2, 10), Address:="", SubAddress:="'" & _
        nf & "'" & "!A1", TextToDisplay:=nf
    endif
  Next i

 

[sofas]

Is this what you mean?

For i = 2 To Sheets.Count
    nf = Sheets(i).Name
    if Len(nf)=2 then
        ws.Hyperlinks.Add Anchor:=ws.Cells(i + 2, 10), Address:="", SubAddress:="'" & _
        nf & "'" & "!A1", TextToDisplay:=nf
    endif
  Next i

Thank you, that's what I mean