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