Export sheet to txt deleting blank rows

[CassioGodinho]

I have a sheet that I need to export to a text file, but in my excel file some cells are blank because of the formula.
On the text file those blank cells are still there and i have to manually delete them. To solve this problem I`m using this code

Please Login or Register  to view this content.

It works fine, but the For Each block takes a little bit to run. Any idea on how to improve this?

[watersev]

hi CassioGodinho, option to delete empty rows basing on A column values, A1 - header:

Please Login or Register  to view this content.

[CassioGodinho]

Thanks man, it worked perfectly.

Could you try to explain me what exactly is the code doing?

[watersev]

autofilter empty cells within the set range, delete autofiltered rows