Sort Method: Run time error

[HortonPB2]

Hello!

I've spent a while now looking online for a solution to my problem, but I'm still getting the same error. I have a range in a worksheet (LAYOUT) that I want sorted first by column B ascending then by column C ascending. I do NOT want to select or activate the worksheet, if that is possible. The code I am trying is this:

Sub Macro4()

Worksheets("LAYOUT").Range("A:D").Sort Key1:=Worksheets("LAYOUT").Columns("B"), Order1:=xlAscending, _ Key2:=Worksheets("LAYOUT").Columns("C"), Order2:=xlAscending, Header:=xlYes

End Sub

Thank you,
Horton

 

[RoryA]

Is the sheet protected? What's the actual error?

Perhaps try:

With Worksheets("LAYOUT")
.Range("A:D").Sort Key1:=.Range("b1"), Order1:=xlAscending, Key2:=.Range("c2"), Order2:=xlAscending, Header:=xlYes
End with

 

[HortonPB2]

Hi Rory,

That didn't work, I'm still getting the runtime error.

Thanks,
Horton

 

[RoryA]

I refer you to my two opening questions then.

 

[HortonPB2]

LoL...my bad. I saw the code...got excited...copied it...tried it...it failed...I cried.

Only then did I go back and read your two questions. The answer is "yes, the sheet is protected." and that was the issue. Adding:

Sub Macro4()​

​

Worksheets("LAYOUT").Unprotect​

Worksheets("LAYOUT").Range("A:D").Sort Key1:=Range("B1"), Order1:=xlAscending, Key2:=Range("C2"), Order2:=xlAscending, Header:=xlYes​

Worksheets("LAYOUT").Protect​

​

End Sub​

Made it work.

I was thrown off because the columns I am selecting were all unlocked. I'll remember next time to unprotect regardless of what I'm doing.

Thanks Rory!!!

 

[RoryA]

Glad to help. Welcome to the forum, by the way.