Jump to content

Excel Sorting


Recommended Posts

Hello,

I'm trying to convert the excel macro line below over to Autoit using the Excel UDF 

 

$oExcel.ActiveWorkbook.Worksheets("Results").ListObjects("Table1").Sort.SortFields.Add Key:=Range("Table1[count]"), SortOn:=xlSortOnValues, Order:=xlDescending , DataOption:=xlSortTextAsNumbers

 

When I run this , I get error 7 and extended value -2147352567
_Excel_RangeSort($oWorkbook,"Results", "A3:C" & $LastRow,"B:B",$xldescending)

What am I missing ?

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...