>Hi Cindy,
>LOL. Numbered columns hit me a lot before that routine :) R1C1 notation is good but doesn't work where I need them most.
>I would ask something about macro recording. You really mean you paste it as is ? I never tried it "as is" thinking "named arguments" would cause problems and refined always. I could try but would like to hear from someone who already did :) TIA.
>PS: I would be pleased to see what you have :)
>Cetin

Well, actually I chopped it up a little before pasting, because each macro was to test a different process like auto-fitting all of the columns, or bolding the first row. I definitely pasted in the number formatting.

Sending you my example by email.