Sort from a specific row onwards

[Squareroot]

Hi,

I am trying to sort some data, if I indicate header:=xlyes it only exclude the first row. However, I need the first 2 row to be excluded from sorting as I have the first 2 rows as header for my table. Does anyone knows how i can exclude the first 2 row when sorting my data using VBA? if it helps below is code for ref. thank you.

Range("C1").CurrentRegion.Sort key1:=Range("C1"), order1:=xlAscending, header:=xlYes

 

[Peter_SSs]

Try this

Range("C1").CurrentRegion.Offset(1).Sort key1:=Range("C1"), order1:=xlAscending, Header:=xlYes

 

[Squareroot]

Try this

Range("C1").CurrentRegion.Offset(1).Sort key1:=Range("C1"), order1:=xlAscending, Header:=xlYes

It works thank you Peter_SSs

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.