Sorting excel in VB.net

[JimReid]

I've done this in Excel macros but can't seem to get it to work in VB.net.

I get the following error: system.Runtime.InteropService.COMException: 'This can't be done on multiple range selection. Select a single range and try again.'

I tried a single range with the same results. Here is the code:

  myRangeMakeup = "D" & StartScoreRow & ",F" & LastScoreRow
  mySortKey = "D" & StartScoreRow
  Debug.Print(myRangeMakeup)              ' Prints D1065,F1123
  Debug.Print(mySortKey)                         'Prints D1065
  myRange = xlWs.Range(myRangeMakeup)
  ' IS: D1065,F1123     and valid                                                                                 

  myRange.Select()
  myRange.Sort(Key1:=myRange.Range(mySortKey),
               Header:=XlYesNoGuess.xlNo,
               Order1:=XlSortOrder.xlAscending,
               MatchCase:=False,
               Orientation:=XlSortOrientation.xlSortColumns)

Debug prints the appropriate ranges.

Had one comment about a , instead of a : between the ranges but tried both with same results.

Also, the continuation underscore keeps disappearing when I put it in.

[ChrisE]

you can define a Range in Excel like this
xlSt is your Worksheet

'....
  'search in Column A
        'Dim rngSearchValue As Range = xlSt.Range("A:A")

        'or in Columns A to E
        Dim rngSearchValue As Range = xlSt.Range("A:E")
'......

or use OLEDB with Sql which is easier IMO

[JimReid]

I understand that ChrisE but that isn't what I'm trying to do. I build the sort range based on what is before it on the spreadsheet so I don't know how many rows are involved until this point. The problem is that this is almost an exact copy of a sample that I was copying but it doesn't work because of the error I noted. Don't understand the error and why.

[TysonLPrice]

Also, the continuation underscore keeps disappearing when I put it in.

That is the nature of Visual Studio now.

[ChrisE]

I understand that ChrisE but that isn't what I'm trying to do. I build the sort range based on what is before it on the spreadsheet so I don't know how many rows are involved until this point. The problem is that this is almost an exact copy of a sample that I was copying but it doesn't work because of the error I noted. Don't understand the error and why.

it is irrelevant how many rows there are if you create the range like I pointed out.

what does your Sheet look like and what is to happen with the filtered/sorted Data ?
display in a Datagridview perhaps?

[JimReid]

ChrisE,
It is important the number of rows. I have 1000+ rows before the group I want to sort. This is why I build a range from 10?? to 11?? for the range of rows. The answer to my question was in the Key1 field. It should have been xlWs.range and not what I had.