I am trying to write a case statement or, number of case statements that is dependent on a loop. For example here is what I've tried to do:
Instead of typing out 5 case statements, I would like it to check the cableod value through the 5 cells as you can see. This doesn't work however. Is this possible?For i = 1 To 5 Select Case cableod Case ws6.Range("A" & i) To ws6.Range("B" & i) With HS .AddItem ws6.Range("C" & i) End With Next i
Bookmarks