Hi ,
If i have a cell with numerical values separated by commas, how can I loop through the numerical values and have a variable numsearch = to each number during the course of hte loop?
Ie follows the logic of:
For number in cell
numsearch = number
. rest of the code goes here
. rest of the code goes here
. rest of the code goes here
. rest of the code goes here
next number
Things to note, all numbers are 5 digits in length only.
Example of possible cell values:
12345
12345,23452,25235
12515,25255
So the loop would go through as many possible numbers as exist in that cell and perform whatever the code needs to do with that number. Then go to the next num (separated by comma) etc
Bookmarks