Data sort by VBA

[Panoos64]

Hi to all of you, kindly require to provide me support so that a VBA code, should sort in an "ActiveSheet" its data used, which start from "A12" till column "K" and "rows down". Therefore that the rows arises to 800000+ and should be sort by col. "F". Thank you all in advance

 

[Fluff]

Is row 12 a header row that needs to stay put?
Also what column can be used to find the last row?

 

[Panoos64]

Hi Fluff, row 12 is not header and should include in sort and column which should valid to find the last row should be "K". Thank you once again for your interesting to resolve my issue!

 

[Fluff]

Ok, how about

Sub Panoose()
    Range("A12", Range("K" & Rows.Count).End(xlUp)).Sort key1:=Range("F12"), order1:=xlAscending, Header:=xlNo
End Sub

 

[Panoos64]

Perfect Fluff! Thank you so much. Hv a great day!!

 

[Fluff]

You're welcome & thanks for the feedback