Conditional Printing

  • Thread starter Thread starter Cindyc100
  • Start date Start date
C

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
 
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
Click to expand...

You could use AutoFilter and select non-blanks from its dropdown!
 
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 -
Click to expand...

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."
 
Back
Top