<div>
Use this:<br />
<br />
mobjXL.Columns(&quot;A:Z&quot;).Enti<wbr />reColumn.A<wbr />utoFit<br />
mobjXL.Range(&quot;A1&quot;).Select<br />

</div>


Use this:

mobjXL.Columns("A:Z").EntireColumn.AutoFit
mobjXL.Range("A1").Select


<div>
Sorry I guess I wasn't clear on the last part. &nbsp;I know how to select a range, what method do I call or use once the range is selected to center columns and add custom formats.<br />
<br />
Thanks so far the autofit works.<br />
<br />
-John
</div>


Sorry I guess I wasn't clear on the last part.  I know how to select a range, what method do I call or use once the range is selected to center columns and add custom formats.

Thanks so far the autofit works.

-John

<div>
The easiest way to find out what methods to use in Excel is to record a macro and perform the change. Looking at the automatically generated code will give you a guide to use.
</div>


The easiest way to find out what methods to use in Excel is to record a macro and perform the change. Looking at the automatically generated code will give you a guide to use.

<div>
Thanks a million, I never would have thought about using a macro, works like a charm. &nbsp;Makes it nice when you are able to cheat honestly for code.<br />
<br />
Thanks again.<br />
<br />
-John
</div>


Thanks a million, I never would have thought about using a macro, works like a charm.  Makes it nice when you are able to cheat honestly for code.

Thanks again.

-John

<div>
<div class="content wysiwyg-content">
I am currently working on an app in Access that uses Excel as the Report Generator, this way my client can edit the report with ease. &nbsp;My question is how can I programmatically format the columns to fit the longest Item, and how can I format a cell with a custom format such as currency/Percentage, an how can I center text in a cell?<br />
<br />
Thanks in advance.<br />
<br />
-John 
</div>
</div>


I am currently working on an app in Access that uses Excel as the Report Generator, this way my client can edit the report with ease.  My question is how can I programmatically format the columns to fit the longest Item, and how can I format a cell with a custom format such as currency/Percentage, an how can I center text in a cell?

Thanks in advance.

-John 

Formatting Excel via VB

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.