Thread: Hide columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chong Moua Chong Moua is offline
external usenet poster
 
Posts: 22
Default Hide columns

A simple way is to use the AutoFilter and filter out the
zeros. Just click inside the data area, then go to Data |
Filter | AutoFilter on the menu bar. Hope this helps...

-----Original Message-----
Hi,
I have a large file, 2 lines and around 140 rows. Line

1:name, Line2
results. Most of line2 is 0, and I would to know if

someone's got a piece of
code which will avoid me to HIDE the rows where the

results is 0and just
display verbose rows !!!!

Cheers mates


.