Excel Automation Align Left

  • Thread starter Jeff via AccessMonster.com
  • Start date
J

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Need Help with Macro Security 1
Excel does not accept text format! 0
Table Preferred width is changed when pasting 1
Outlook 365 overriding formatting choices 0
Autonumber field in Excel that behaves the same as Access 0
Align text in list boxes? 1
alignment of SOME text in a textbox 10

Top