Mr. Sjoblom: Thanks for info. What would that macro be in Excel 2003?

In my mind, I would create a macro that is the equivalent of pushing the
paintbrush icon. I would make it a keyboard macro, probably CTRL + SHIFT + C.

I don't think we need a macro to "paste" the formatting since the "pasting"
is done as soon as you touch a cell or sweep a range of cells. Am I correct?

Thanks.