Can anyone speak to the performance issues between copying and pasting a
range of formats vs programmatically setting formats? It seems that it is
much faster to copy and paste, than looping through a range, and I am
wondering if anyone has any input on this.

We currently keep a template sheet, but I would like to move away from this.

Thanks in advance.

Regards,
Adam