How to remove blank rows in a Excel worksheet?

[premMS143]

Hi 1 & all,

Using VB,
How to remove blank rows in a Excel worksheet?
For example,
I'm having a Excel sheet containing 900 rows data, in which there are blank rows inserted in between. Manually I deleted 450 rows & is there any way to do this using VB? Please guide me.


Thanx & regards,
Prem

[prabirchoudhury]

hey..
have look on this tutorials , would be helpful Delete File On Excel VBA