Sorting by a column in MS Excel - VBA

Question

I am trying to sort a column using VBA in Excel. This is my code,

Range("B:B").Sort _
Key1:=Range("B2"), Order1:=xlAscending

But, It sorts the header column as well. I didn't want the Header Column to be included in the sorting , So I tried the following code,

Range("B1:B").Sort _
Key1:=Range("B2"), Order1:=xlAscending

Which didn't work either. Is there anyway to tell the VBA that my first column is a header name while sorting? Kindly share your thoughts.

AdzzzUK · Accepted Answer · 2017-04-03 14:44:42Z

5

Add the following to the code:

Header:=xlYes

So it becomes:

Range("B:B").Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlYes

answered Apr 3, 2017 at 14:34

AdzzzUK

2051 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1