Thanks Charles. Yea I understand it won't work as it since it's looping over tables. I actually used this macro to update tables caption and it worked great. I tried to change "Tables" in macro but couldn't find exact one used for figures. I tried your version of code and unfortunately it didn't work. It says "Object doesn't support this property or method" and it's indicating "Figures"