Missing in Loop for Data Validation [Closed]

Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Hello,

I would like to request that in the given code please add this feature that at every 14 rows data validation applied and then skip 5 rows after that again every 14 rows data validation is applied such as
In ranges C3 to C178 that it would create Data Validation from C3 to C16
Then again it will start from C21 end to C34
And this carry on to C178

Sub NewLoopDV()
Dim x As Integer

For x = 3 To 178 Step 18
With Range("C" & x & "").Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop, Formula1:="=C" & x & "<=B" & x & ""
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "Invalid Quantity"
.InputMessage = ""
.ErrorMessage = "It Must be enter less than or equal to Quantity Delivered"
.ShowInput = True
.ShowError = True
End With
Next x
End Sub


I hope that i convey my request correctly

Thanks