Hide Rows using a returtn value in a column

C

Carpe Diem

Hi,

I have the following data:

0 0 FORNECIM. SERVIÇOS EXTERNOS
0 0 CONDOMÍNIO
0 0 ELECTRICIDADE, ÁGUA E GÁS
62214001 T GÁS
62213001 T ÁGUA


I would like to create a macro that will hide the rows when column 2
as the value "0"

Can someone help me ?

Thank you
 
C

Carpe Diem

I have a lot of sums in the table, if I use total its dificult to
control. So I need to use VBA
 
C

Carpe Diem

I have a lot of sums in the table, if I use total its dificult to
control. So I need to use VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Macro to hide rows 4
How to write a macro to hide an entire row 9
A data validation question 1
Excel VBA 1
If statement based on cell formatting/style 2
hide colum based on cell value on each worksheets 2
modified pivot table using a macro 2

Top