View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Hide Rows using a returtn value in a column

How about using an AutoFilter??? Data - Filter - AutoFilter -
--
HTH...

Jim Thomlinson


"Carpe Diem" wrote:

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