Sort Range Using VBA And Ignoring Or Discarding Blank Rows

[analyst]

I am trying, instead of putting all range in single line, am making different block, and it is working, thank u. Thank you Admin.