View Single Post
  #1 (permalink)  
Old March 26th, 2004, 04:25 PM
deanna deanna is offline
Registered User
Join Date: Mar 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default trying to sort data in excel with

here's my code:

ExcelGlobal_definst.Range("a1:bo36").Sort(Key1:=(" a1:bo36"), Order1:=Excel.XlSortOrder.xlAscending, Header:=Excel.XlYesNoGuess.xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=Excel.XlSortOrientation.xlSortRows, DataOption1:=Excel.XlSortDataOption.xlSortNormal)

there are no compile errors, but while running the program tells me I have an error in this formula. I'm trying to sort range a1:bo36, ascending, according to column A.