Delete the blank rows in the report.

[Mahendra Kulkarni]

Hi All,

I need your help. I'm trying to write a vba program to import a report in .txt format to excel and then format it.
I want to delete the blank rows from the excel report. can any body suggest how to?

Many thanks in advance.

Regards,
Mahendra

[stnkynts]

It depends on a few factors which you haven't identified. This might work assuming you are looking at column A. For a more exact answer you should always submit an example copy of your workbook.

Please Login or Register  to view this content.