Option Explicit
Sub Test()
Dim X As Integer
For X = 5 To Feuil2.Range("C65536").End(xlUp).Row
On Error Resume Next
If Feuil2.Range("B" & X) = "" Then X = X + 1
Feuil2.Range("C" & X).ShowDetail = True
ActiveSheet.Name = Left(ActiveSheet.Range("C2"), 26)
Next X
Sheets("TCD").Move Before:=Sheets(2)
End Sub