Txt File Creator to ignore blank rows

[Juve_Fan14]

Hi Guys,

I currently have quite a large Module that turns rows of data into a txt file, however if a row is blank it stop the txt file there and doesn't add the next lines into the txt file. How can i get the module to skip the blanks and add the rest of the lines that are under it. I don't want to delete these blank rows as they hold formulas where they may not be blank upon a condition.

I did not create this module and it's quite large, with all types of checks being performed, just nothing about blank lines.

Any help is hugely appreciated.

[Marc L]

Hi,

obviously obvious : just amend the code to not stop the process in case of any blank row …
At beginner level you can use Excel basics like a filter or an advanced filter for example.

How can it be a large module as for creating a text file often few codelines are necessary ?

[mjr veverka]

... I don't want to delete ... blank rows ...
... all types of checks being performed, just nothing about blank lines ...

Are you sure about this ?

[Juve_Fan14]

Hey guys, thanks for the replies.

Correct, so the .txt file then has to be imported, however it has to be set up in a very specific way for the import to be successful, for example Post Code must be 4 digits(Australia), there can't be symbols in fields, it also tracks that some data hasn't been removed/edited and number of other checks I'm not too familiar with.

The trigger for the end of the .txt file is blank line.

I've realised another way I can do it is to have all the data (including blank lines) in another sheet and have the main sheet bring over all the non-blank lines with a separate code. I have a code that gets it close to what I want, I'll keep playing around and ask again if I can't get it.

[mjr veverka]

Based on what could we help you with ?
We don't have from you neither the example of the data (false data but the real data layout) nor the code (to verify its syntax).
The simplest solution would be to combine cells into one long 'string' to check if it is zero length or another and to combine it with the conditional statement 'If', which will decide whether to perform the given operations or not.