complete page numbers

[DocAElstein]

Hello Moshe,
You are welcome, and thanks for the update.
jindon is a VBA genius! or maybe he has good library of many codes and for this reason is very fast. I have experienced this many times at excelforum!
I started my solution, so out of interest I finished it.
But almost certainly the code form jindon is the one to use.

Here is my solution, - Here is my code for you:
http://www.excelfox.com/forum/showth...0496#post10496




The code will take something like this:_....

Row\Col	A	B
1	34-5
2	3, 6-8, 24-56, 78, 123-45, 254-65
3	55-6, 122-6, 156-68
4	45, 255-8, 212-24
5

_.... and give you something like this:

Row\Col	A	B
1	34-5	34-35
2	3, 6-8, 24-56, 78, 123-45, 254-65	3, 6-8, 24-56, 78, 123-145, 254-265
3	55-6, 122-6, 156-68	55-56, 122-126, 156-168
4	45, 255-8, 212-24	45, 255-258, 212-224
5

_.__________________________

( Now I will study the solution form jindon and see if I can understand it ! )

Alan

[moblid]

Great, thanks so much! the update fell into spam which is why I didn't respond earlier. both yours and Jindon's work.
Moshe