Conditional Printing

[Cindyc100]

Hi. I have a list of rows:

A1
A2
A3
A4
A5

If A4 is blank, I just want it to print as follows:

A1
A2
A3
A5

....with no blank spaces -- and all this, depending on the value of a
given cell.

Any ideas?

Thanks!

Cindy

 

[GS]

Cindyc100 presented the following explanation :

Hi. I have a list of rows:

A1
A2
A3
A4
A5

If A4 is blank, I just want it to print as follows:

A1
A2
A3
A5

...with no blank spaces -- and all this, depending on the value of a
given cell.

Any ideas?

Thanks!

Cindy

You could use AutoFilter and select non-blanks from its dropdown!

 

[Don Guillett]

Cindyc100 presented the following explanation :







You could use AutoFilter and select non-blanks from its dropdown!

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

You haven't given a very good explanation.
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."