using an array in a Like statement

D

Drayel

Joined
Apr 25, 2010
Messages
1
Reaction score
0
I am trying to make an like statement that checks the contents of an array to the contents of a cell and if it finds the statement to be true, it will edit the value of another cell. The array are all the values that i want to check for.

Code: 
MANUAL [1] = "1635*"
 MANUAL [2] = "1643*"  '(there are 22 other elements of the array)
 
 For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
 	For r=1 to 2 
 		  If Range("B" & i) Like(MANUAL [r]) Then Range("L" & i) = "MANUAL ALLOCATION"
 	Next
 Next

Thanks
Drayel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Never ending ARRAY code problems 18
VBA Multiple Line handling with Split() 1
Array with many cells from a row but not in order or together 11
Loop is slow trying array code 17
Array VLOOKUP lookup_Value does not increment 3
Permutations andText to column problem 6
Error with calling Format sub 7
Cell values to an array, then array transpose to another workbook 8

Top