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

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Feb 8, 1:02*pm, GS <g...@somewhere.net> wrote:
> 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!
>
> --
> 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."