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 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...

I would suggest you'd have more success posting in an Excel newsgroup rather
than one for Outlook. Good luck!

--
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
http://www.howto-outlook.com/



"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 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...

Hi Orland,

Thanks for the suggestion.

"K. Orland" wrote:

> I would suggest you'd have more success posting in an Excel newsgroup rather
> than one for Outlook. Good luck!
>
> --
> Kathleen Orland - MVP Outlook
> Outlook Tips: http://www.outlook-tips.net/
> http://www.howto-outlook.com/
>
>
>
> "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 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...