Can I exclude a column when sorting with VBA

[Needinghlp]

Hi everyone, I am using the code below to conduct a sort and I wondered if it is possible to exclude a column when sorting i.e. could I exclude column R from the sort so that it remains as is. I have been looking for similar questions and it appears maybe this isn't possible but just wanted to put the question out there in case I've missed the answer. Many thanks.

Private Sub CommandButton1_Click()
'vba_sort_range()
Range("a3:AA1021").Sort Key1:=Range("x3"), _
Order1:=xlDescending, _
Key2:=Range("q3"), _
Order2:=xlDescending, _
Header:=xlNo

 

[Fluff]

Not quite sure why you would want to do that, but it's not possible.

 

[Michael M]

If you are sorting either side of column "R", which it appears you are....why would you want to exclude a column ??
That would make the data invalid, as the rows would be misaligned !!
Otherwise, short answer is No, you can't

 

[rhombus4]

Just move column R to column AB outside your sort range

Or do 2 sorts a:q and s: aa

 

[Fluff]

@rhombus4 as the 1st sort key is col X you cannot do two sorts as you have suggested.

 

[rhombus4]

@rhombus4 as the 1st sort key is col X you cannot do two sorts as you have suggested.

Oops didn't notice the sort key