>>>In VS you don't have to use such tricks to have intellisense kicked in.
>>
>>Because Office and dot-net are not manufactured by a competing company like Fox was.
>
>Can you please help me with with the question 2?

Centering everything in a whole range? I'd just select the whole range and set the formatting the way I wanted it, then see the recorded macro. It would be helpful if the sheet was based on a template sheet, so you could have the pre-defined named ranges in advance - so if you insert a column or move things around a bit doesn't require changing the code, as long as the names of the ranges stay.

But then on a template sheet you'd have the headers on it already centered, so the question would be moot.