Can someone help me add a modification to this macro that Deepak wrote? It works perfectly for what I need. It looks at the original name of the sheet format, and reloads it, however can it be tweeked? We have dropped down to using only 2 sizes of sheet format (C & D). I would like the C & D to be reloaded with the new version, but if it finds another size (ex. B) I would like it to default to C Size? Is this possible? Thanks in advance.