Macro: Columns as #s within range

[shternm]

I have a simple formatting macro within a range.
I would like to set up columns within an identified range as 1,2, 3 or
A, B,C even if it's doesn't correspond to continuous column numbering
in excel.

I know it seems strange, but this macro will run a number of times
within each sheet and I don't want to go into each and every one to
reset it with the corresponding letters.

Thanks a lot.

 

[Dave Peterson]

How about something like:

with activesheet.range("a:a,d:d,G:G")
.numberformat = "#,##0.00"
end with

(but I may have misunderstood your question.)