Add sort function to dynamically highlighted range

[christianbiker]

Hi all,

I found this code (Thanks Fluff!) that highlights my dynamic range perfectly but I need to be able to now sort that range when selected by column B (Largest to smallest).. Would appreciate any assistance.

Range("A4", Range("A" & Rows.Count).End(xlUp).Offset(, 1)).Select

Thanks!

 

[Fluff]

How about

Range("A4", Range("A" & Rows.count).End(xlUp).Offset(, 1)).Sort key1:=Range("B4"), order1:=xlDescending, Header:=xlYes

 

[christianbiker]

Works awesome! You have always helped me a ton Fluff. Thanks once again!

 

[Fluff]

You're welcome & thanks for the feedback.