PC Review Forums Newsgroups Microsoft DotNet Microsoft VB .NET Help: Excel sort from VB.Net - How?

Reply

Help: Excel sort from VB.Net - How?

 
Thread Tools Rate Thread
Old 16-11-2006, 12:49 AM   #1
Greg
Guest
 
Posts: n/a
Default Help: Excel sort from VB.Net - How?


Hi,

Any ideas of the syntax required to perform an Excel sort from VB.Net?

Are there any Imports statements required, etc.?



Also, if I want the data in Column B centered, I use:

oSheet.Columns("B:B").HorizontalAlignment = 2

How can I relate this to xlCenter rather than using the number 2?



Thanks,

Greg.


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off