Filter Shows Blank Rows in Selection

Hello
i Have a problem. I want to delete all (blank) rows from my Excel Sheet. I have written the code like this.

Please Login or Register  to view this content.

This Code does not shows blank rows at first time. but when i select any other value from filter it starts to show (blank)......

Pls help me to solbe this..........as its very urgent

Progress2007

Please use Code Tags in future.

Originally Posted by Progress2007

Pls help me to solbe this..........as its very urgent

Your problem might be urgent to you, but we are providing free help, so you should take the time to respond to your previous questions and acknowledge the help received with thanks!