Help on a UDF, Find consecutives numbers In single Cell, with "-"

Hi all,

I know is boring what i'm going to ask you...
(Before this post, on this forum i search 1906 post about consecutive, and none of those match my need.. )
So
I need find consecutive Numbers in a singles Cell but each numbers have a leading zero and "-"
(Dash)

My problem is that the UDF that i found on this forum, is for numbers with out leading zero with coma ",",
so even if change the "," by "-", still getting a error Because the Code is designed to Read numbers Formats different than mine..

My Numbers are located in Cell G12 (down), and the message that i need to show
in the cell result is :

If Found :
0 Consecutives --> 0
2 Consecutives --> 2
3 consecutives --> 3
4 consecutives --> 4
5 consecutives --> 5
2 Set of consecutives --> 2S

Example of 0 consecutives --> 01-04-07-12-25-30
Example of 2 consecutives --> 01-02-07-12-25-30
Example of 3 consecutives --> 01-02-03-12-25-30
Example of 4 consecutives --> 01-02-03-04-25-30
Example of 5 consecutives --> 01-02-03-04-05-30
Example of 2 sets of consecutive s --> 01-02-07-12-25-26

BTW my numbers start on Cell G12 down..
______G12_______
01-02-03-20-21-25


This is the Module that i'm getting hard time... Please any help??

Please Login or Register  to view this content.

Thank you so much




Best regards

David

Hi david,

Try this:

Please Login or Register  to view this content.

Hey David,

You asked for a UDF and the above doesn't really do that. Find attached a much better answer. It will handle longer strings and you can put them anywhere in the sheet. You don't need to put them in Col H.

I think this is what you are really wanting anyhow.

Most likely you didn't have 5 numbers separated by dashes. The below UDF answer is much better as it uses the number of numbers in the array instead of trusting there will be exactly 5 numbers.

The UBound(Arrs) tells how many numbers there are. Step through the code in the attached file below and see if you have questions about it... Feel free to ask...

http://www.excel-easy.com/vba/examples/debugging.html or
http://www.cpearson.com/Excel/DebuggingVBA.aspx

Hi Mr Jindon,

Thank you so much !!!, i haven't try your code but i will,

By the way, important code in my sheet came from you !


Thank you a lot !!

Best regards

David

I really like John Walkenback's style. Here is his first basic VBA book.

http://www.amazon.com/Excel-Programm.../dp/1118490371