Set hoursRange = Range("G" & nextRow & ":" & ColLetter & nextRow)

With hoursRange.Validation
    .Delete
    .Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=0", Formula2:="=24"
End With