Hello,
I am trying to compare a value to a range of values. I have many to compare to so AND is not an option, writing is too long, unless it is possible to put in an AND many values. And I can't use for loop to do something like Range("H"& integer).Value This is my shortened code that does not work because of the way I write Range syntax there:
Dim x As Integer For x = 35 To 44 If x <> Range("H1:H100").Value Then Cells(x * 12 - 10, 6).FormulaR1C1 = "Country ID" Cells(x * 12 - 10, 7).FormulaR1C1 = x End If Next x
Bookmarks