Try recording a macro when you do the formatting manually.

Srikanth wrote:

Hi,

I wanna create a macro in excel to format my sheet when ever i pull it from
our company's software. That sheet changes from time to time ex: no of
columns & rows.. not same everytime. But that report is not so perfect.. I
wanna run a macro to format that sheet so that I can save the time.

When I pull that sheet it consists of merged cells, then I've to remove
merged cells, I've to center align them and I've to autofit them.... so that
its completed..

Can any one suggest me doing this.

Thanks in advance...

--

Dave Peterson