Sort values blank cells first

[sans]

Hello,

I am trying to sort a range which contains number by having the blanks sorted out first. Is there a formula or vba solution to achieve this?

Many thanks.

[nilem]

Hi sans
maybe something like this

Please Login or Register  to view this content.

[sans]

Thanks for the reply nilem. The macro works great. For some reason when I run it in the attachment above it works as expected but when I run it in my normal document I get no activity. Can't figure out why. Many thanks!

[sans]

Can the above be done with a formula? I need to use this function very often and a formula would be much faster to work with.

Thanks!