Sort by Length on Range A52:A54

I need to either adjust this macro so that it will work with the range A52:A54 sorting them by length putting the longest text at the top.

The one I found after I change it around a bit works if starting at A1... if starting any where else it changes everything above to an #N/A

Thank you for your help

Macro I found and currently trying to adjust

Please Login or Register  to view this content.

Hi meabrams,

Try the following (changes in red):

Please Login or Register  to view this content.

Lewis

meabrams,

Isn't it just

Please Login or Register  to view this content.

I will try these both after I get up in the afternoon...

Thank you both I ended up going with LJMetzger way, but I will keep jindon way for next time it does look cleaner though