Hi,

Looking for a macro that can replace all the sheet formats of an active drawing with new specified formats.

I tried "TemplateSwitch" macro from http://www.lennyworks.com and it works great, but with one minor exception: The macro replaces all sheets of the drawing with the same format.

I use a different sheet format for sheet 2,3.... for sizes C, D, & E, and would like to be able to specify a different format for sheet 2 for sizes C, D, & E. So when the macro runs, it checks for current sheet size, and then replaces all sheets accordingly if more than 1 sheet exists in the active drawing.

Thanks in advance for any help.

Raúl