Thread: hide columns automatically
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chicom17 Chicom17 is offline
external usenet poster
  
Posts: 1
Default hide columns automatically
Sheet A & B look like this
Month Jan- Feb -March-April- May -June
Select 1 1 1 0 0 0

If i capture 1 on sheet A it will reflect on Sheet B. I need to atomatically
hide 0 columns on sheet B, and this colums wil automatically show when i
capture 1 on sheet A
Reply With QuoteReply With Quote