goofy78270
Well-known Member
- Joined
- May 16, 2007
- Messages
- 555
I am looking to search quickly for a number within a cell.
Using a macro, I am looking to search something like:
1,2,3,4-12,45,67,200
to see if the number 11 is contained.
I have recently wrote a macro that splits out the field into an array based on the "," and then again on the "-" while filling in the missing numbers but this is pretty time consuming. Is there an easier way to simply search for the number in question?
Using a macro, I am looking to search something like:
1,2,3,4-12,45,67,200
to see if the number 11 is contained.
I have recently wrote a macro that splits out the field into an array based on the "," and then again on the "-" while filling in the missing numbers but this is pretty time consuming. Is there an easier way to simply search for the number in question?