Application-defined or object-defined error on sort command

[raeannb]

Hi! I have the following line of code that keeps giving me a "Run-time error '1004': Application-defined or object-defined error," and I can't seem to figure out why:

.Range(.Cells(7, 1), .Cells(x, lastcol)).Sort Key:=Columns(mycol), Order:=xlAscending, Header:=xlYes

My table extends from cell A7 to row x, column "lastcol," both of which are being found correctly (I checked). The line is preceded by a With statement selecting the worksheet I want to use. The column I'd like to sort by is
"mycol," another integer being found correctly. I've never embedded a .Cells statement in a Range statement before, but I read online that it should work, sooo....what the heck am I doing wrong?

Thank you!!

 

[Jonmo1]

I think you also need to declare the sheet on the Key...
And both key and order need to be numbered (key1 order1)

Try

.Range(.Cells(7, 1), .Cells(x, lc)).Sort key1:=.Columns(mycol), Order1:=xlAscending, Header:=xlYes

 

[mikerickson]

is 1 <= mycol <= lastcol ?
have you tried Key1:=.Cells(7, mycol)

What With...End With is this inside?

Perhaps removing the dot from Range.

With someThing
    Range(.Cells(7, 1), .Cells(x, lastcol)).Sort Key1:=.Cells(1, mycol), Order1:=xlAscending, Header:=xlYes
End With

 

[raeannb]

I think you also need to declare the sheet on the Key...
And both key and order need to be numbered (key1 order1)

Try

.Range(.Cells(7, 1), .Cells(x, lc)).Sort key1:=.Columns(mycol), Order1:=xlAscending, Header:=xlYes

It worked!!! As dumb as I feel, I love quick fixes...thank you!!

 

[QuestionBaker]

It worked for me too, but in one of my earlier codes, I was able to use it without key1 and it still worked...
idk what I did there.