question on VB-sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Change
Range("e95:g108").Sort key1:=Range("e95"), Order:=xlDescending

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


Kevin Backmann
 
many thanks Kevin.it works.

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

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


Kevin Backmann
Click to expand...
 
Back
Top