asked on

Two Excel questions

Basics: VB6 sp5, Windows/NT, Excel 2000

In my VB application I create and populate an Excel worksheet successfully. Now I want to do two additional things to the spreadsheet as follows:

1. How do I sort the spreadsheet based on two columns? Column A should be ascending and Column B descending. However, the sort should start with row 3 as rows 1 and 2 are column headers and thus should not be sorted.

2. How do I right justify a certain cell in the spreadsheet?

Thanks for the help.

ASKER CERTIFIED SOLUTION

roverm

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

roverm

Of course, above code was written in VBA (Excel) just alter it to run from VB or place the code in the Excel workbook and run it as an macro (Application.Run "Sortit").

D'Mzzl!
RoverM

EYoung

ASKER

roverm,

I tried to sort the spreadsheet using the following code but it does not appear to be working. Do I need all of the parameters, i.e. Header, OrderCustom, Orientation, etc.? (For testing purposes I am including the first two rows in the sort just to see how it works.)

W.Cells.Sort Key1:=Range("C1"), Order1:=xlAscending, Key2:=Range("E1") _
, Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom

Thanks

EYoung

ASKER

Do I need to specify the rows to sort or expand the Range option? (Does Range("C1") mean sort all of column C?)

EYoung

ASKER

Thanks. It works just fine.

roverm

Your first comment:
No, you don't need them all, every prop got it's own default. Like Orientation = xlTopBottom.
Just try to leave one out and see ;-)

Second comment:
Yes, Range("C1") means ON what column to sort. To select a range:
Columns("A1:E1").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Last comment:
Thanks for the points !

Glad I could help.

D'Mzzl!
RoverM