VBA check if value in list

Asked Feb 01 '22 at 20:18

Active Feb 01 '22 at 20:18

Viewed 25 times

How can I change my code below to check if the value is in my list? ALso, How can I change the for C = 1 to 1000 to make it automatically check from 1 to n where n is the total amount of columns?

Dim c As Long, r1 As Range
arrList = Array("A", "B", "C", "D")
For c = 1 To 1000
    If Cells(1, c).Value = "A" Then
        Cells(1, c).Select

asked Feb 01 '22 at 20:18

JPWilson

You just loop `arrList`. – BigBen Feb 01 '22 at 20:19
https://stackoverflow.com/a/50649967/9245853 for how to find the last column. – BigBen Feb 01 '22 at 20:21
Also see [how to avoid using Select](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba). – BigBen Feb 01 '22 at 20:25

VBA check if value in list

0 Answers0