Two Excel questions
Posted on 2001-09-10
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.