Hi gmayor

Thanks for providing the code.

If i try to run this macro in my file, the following error occurred and some of the instances not expanded.

Error name: "Overflow (Error 6) "

Have you set any limitation set this macro to expand the value. I have large data to change expand the values. I am just given the some of the data's only as a example file.



Please check and let me know.

Thanks

Hi gmayor

The problem is some if the numbers start between, for ex., 5-7, 8-25 etc....

The below code only convert from 1 to up to whatever in the file.

Sorry its my fault to mention that the occurrences.

I am just found the below instances too...

<fir fin=“MP5“/>-<fir fin=“MP17“/>,
<fir fin=“MP6“/>-<fir fin=“MP8“/>
<fir fin=“C4“/>-<fir fin=“C7“/> etc...

Please help me out on this too....