Sub AvailableDates2()
UserForm1.Show
For Each RoomNumber In ThisWorkbook.Names
RoomNumberConfirmation = Left(RoomNumber.Name, 2)
RoomName = RoomNumber.Name
If RoomNumberConfirmation = "Ch" Then
MsgBox Application.VLookup(RoomName, [DATAS], 2, False) ' -> A SUPPRIMER ->Application.Evaluate("VLOOKUP(" & RoomName & ",LIST!C5:D50,2,FALSE)")
'je le laisse faire les modifs finales ;-)
'BedColumn = Application.Evaluate("VLOOKUP(" & RoomName & ",LIST!C5:D50,2,FALSE)")
'
'Sheets("Test_visuel").Select
'Availability = Application.Evaluate("VLOOKUP(B14,DATA!A1:EW36," & BedColumn & ",FALSE)")
'
' 'Vérifie disponibilité et change la couleur
' If Availability = 0 Then 'disponible = 0
' Range(RoomNumber).Interior.Color = RGB(146, 208, 80) 'green
' Else
' Range(RoomNumber).Interior.Color = RGB(192, 0, 0) 'red
' End If
'
'Else
End If
Next RoomNumber
Range("A1").Select
End Sub