Sort column excluding header

[riley454]

I have a column (with a title in row 1) containing a list that I want to sort alphabetically prior to performing other actions. Using the following code, everything is sorted alphabetically as expected but unfortunately includes the header/title from row 1.

How can I perform this simple sort function in VBA without including the title/header as part of the sorting?

As a side note the number of rows of data in column GZ may change so I'm not able to state a simple Range(GZx : GZy) in the selection

Set srtR = Sheets(sht).Range("GZ:GZ")
srtR.Sort Key1:=Range("GZ:GZ"), Order1:=xlAscending

 

[mohadin]

Sub test()
    Set srtR = Sheets("sht").Range("GZ2:GZ" & Cells(Rows.Count, "GZ").End(xlUp).Row)
    srtR.Sort Key1:=Range("GZ:GZ"), Order1:=xlAscending
End Sub

 

[riley454]

Thanks mohadin that's exactly what I needed. I was sure it would be something simple but it's getting late and I was over thinking it

 

[mohadin]

You are very welcome
And thank you for the feedback
Be happy and safe