Prev: Compare two lists and get differences
Next: Array problem? List comparison?
From: Javed on 28 Apr 2010 23:54
On Apr 28, 11:01 pm, Dave Peterson <peter...(a)verizonXSPAM.net> wrote:
> xl2007 still supports the old syntax.  So you could create the macro (record
> it???) in xl2003 and it'll work ok.
>
> This may help (or not!):
>
>     Dim wks As Worksheet
>     Dim myRng As Range
>
>     Set wks = Worksheets("Sheet9999")
>
>     With wks
>         Set myRng = .Range("A3:x" & BO_DownloadWS_lastRow)
>     End With
>
>     With myRng
>         .Cells.Sort _
>             key1:=.Columns(1), order1:=xlAscending, _
>             key2:=.Columns(3), order1:=xlAscending, _
>             header:=xlYes
>     End With
>
> This is sorting A3:X(lastrow) by columns A and C.  And the data has header in
> the first row.
>
> Ayo wrote:
>
> > I have this line of code in my macro. Someone with Excel 2003 can go past it.
>
> > BOReportWS.Sort.SortFields.Clear
>
> > Is there a way to get it to run in xl2003?
>
> > 'BOReportWS.Sort.SortFields.Add Key:=Range("A3:A" & BO_DownloadWS_lastRow)
>
> --
>
> Dave Peterson

This line is wrong key2:=.Columns(3), order1:=xlAscending, _
This line is correct key2:=.Columns(3), order2:=xlAscending, _
From: Dave Peterson on 29 Apr 2010 08:25
Thanks for the correction.



Javed wrote:
<<snipped>>
>
> This line is wrong key2:=.Columns(3), order1:=xlAscending, _
> This line is correct key2:=.Columns(3), order2:=xlAscending, _

--

Dave Peterson
 | 
Pages: 1
Prev: Compare two lists and get differences
Next: Array problem? List comparison?