question on VB-sort

[Guest]

hi,
I see an error when I run the following code.the order focuses on "order"
poping up a message like"named argument not found"??any help?

Private Sub CommandButton16_Click()
Sheets("sheet1").Activate
Range("e95:g108").Sort key1:=Range("e95"), Order:=xlDescending
End Sub

thanx

 

[Guest]

Change
Range("e95:g108").Sort key1:=Range("e95"), Order:=xlDescending

To
Range("e95:g108").Sort key1:=Range("e95"), Order1:=xlDescending


Kevin Backmann

 

[Guest]

many thanks Kevin.it works.

Change
Range("e95:g108").Sort key1:=Range("e95"), Order:=xlDescending

To
Range("e95:g108").Sort key1:=Range("e95"), Order1:=xlDescending


Kevin Backmann