Excel Automation Align Left

[Jeff via AccessMonster.com]

Anyone know how to align cells using vb code. I use excel automation to dump
a query into excel and I'm now formating the spreadsheet to look more
professional but I can't seem to align left - any ideas?

 

[Douglas J. Steele]

Excel lets you record macros. Turn on the recorder, format the cells the way
you want them, then look at what was recorded.