Umesh,
I have previously provided you with a quite extensive macro that includes, amongst other things, code for deleting blank rows.
Rather than simply treating this forum as a free coding resource, it would be better if you invested some time in seeing how previously solutions might be adapted to new situations.
Of course, we're always here to help if you get stuck.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|