can you hide rows with a formula?

on my last sheet there should be an overview of the data selected by the
user. If the user doesn�t select all the blocks with data �because he thus
not need that particular block�. There will be empty rows between the
information on the last sheet!
I need all the info under each other, so that the user will have a short
clear overview that will fit on 1 page to print. (this should be all
automatic).

Is this possible by hiding the empty rows with a formula? Or is there
another way?

(The sow called �empty rows� do contain formulas that hide the data blocks
that the user thus not need)

Please help me I have tried so many things and still without resold.

Greets david

I dont know of a formula to do it but its quite easy in a macro...
Columns("F:F").ColumnWidth = 0

or if you want it to run on all the columns that are currently selected...
Selection.ColumnWidth = 0

Pls only post in ONE ng. We read em all

--
Don Guillett
SalesAid Software
[email protected]
"david" <[email protected]> wrote in message
news:[email protected]...
> on my last sheet there should be an overview of the data selected by the
> user. If the user doesn't select all the blocks with data "because he thus
> not need that particular block". There will be empty rows between the
> information on the last sheet!
> I need all the info under each other, so that the user will have a short
> clear overview that will fit on 1 page to print. (this should be all
> automatic).
>
> Is this possible by hiding the empty rows with a formula? Or is there
> another way?
>
> (The sow called "empty rows" do contain formulas that hide the data blocks
> that the user thus not need)
>
> Please help me I have tried so many things and still without resold.
>
> Greets david
>
>
>

ok thank you



------------------------------------------------------------------------
"Don Guillett" wrote:

> Pls only post in ONE ng. We read em all
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "david" <[email protected]> wrote in message
> news:[email protected]...
> > on my last sheet there should be an overview of the data selected by the
> > user. If the user doesn't select all the blocks with data "because he thus
> > not need that particular block". There will be empty rows between the
> > information on the last sheet!
> > I need all the info under each other, so that the user will have a short
> > clear overview that will fit on 1 page to print. (this should be all
> > automatic).
> >
> > Is this possible by hiding the empty rows with a formula? Or is there
> > another way?
> >
> > (The sow called "empty rows" do contain formulas that hide the data blocks
> > that the user thus not need)
> >
> > Please help me I have tried so many things and still without resold.
> >
> > Greets david
> >
> >
> >
>
>
>