Hide Rows

[shail]

Hi,

I have a dropdown validation list. When I select an item from this
list, the rows below will be populated using the HLOOKUP function. The
HLOOKUP function brings the values from the other sheet. The records
will be one to one thousand. And I have the formula upto 1000 rows.
When item has just one value in it the other rows will have the value
zero.

I need to hide those rows which have the zero values. I could have use
the Autofilter, but I need it when the item is selected from the
dropdown list. So this could be done using VBA code.

Please help

Shail

 

[Tieske]

Do you truly want them to disappear? or do you just not want to see them?

In the latter case, use "conditional formatting", if the cell value is zero,
then use the same tekstcolour as the background colour. This way all the
zero's will seem to disappear.

Tieske

 

[Guest]

Tools > Options > View tab and uncheck Zero values