Numbered column in vba

**PcMax** · 07-02-2012, 01:58 AM

Hi,

I have tried and tested various suggestions recommended.
Code Working successfully Thank Snb

**Rick Rothstein** · 07-02-2012, 02:20 AM

Originally Posted by PcMax

I have tried and tested various suggestions recommended.
Code Working successfully Thank Snb

One caution with snb's code... it will work fine as long as all the values in your list are the same length (as you showed in your posting). However, if the length of the list items can vary, and more importantly, if a smaller value can be found as part of a larger value (for example, if your list could have both 1850 and 41850 in it), then snb's code will return incorrect answers.