if the line doesn't contain any data? I am printing a list of addresses and sometimes the 2nd line doesn't contain any data because there is no apartment number or suite number. So, in order to save space, I just don't want this line to print if there is nothing to print rather than getting a blank line that takes up space. In the past, I'd use conditional formatting to make the characters white if they were zeros, but they would still take up blank space. This time, I'd like the line to not print. Any ideas? Thanks!