Dynamically Sort Text & Numbers (Ignoring blanks)

[Bicky]

Hello All

wonder if someone can help. I need to dynamically sort an excel sheet. I have used the code from the lesson 759 Youtube vide (http://www.youtube.com/user/ExcelIsFun?feature=watch#p/search/0/IZLAzIYfMDU) but I have noticed it doesnt work if you have blanks and/or numbers within the column you want to sort.

Does anyone know how to adapt to code so that blank fields are ignored and numerical values are at the top of the sort.

Any help would be great

Thanks