Dear All,

I am faced with a tough situation due to which I am not
able to make a file presentable. For reporting purpose I
have to download files from my office system in excel.
But the problem is that on downloading the system creates
lots of blank rows in the excel file. Now the size of the
download varies every time and also the number of blank
rows between 2 records is not fixed. To counter this I
wish to generate a macro which would identify the blank
rows in the file and delete it automatically.

If anyone has a solution to this kindly let me know the
macro for the same. Thanking you all for the support.

Regards,
Raj