View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BatMan BatMan is offline
external usenet poster
 
Posts: 2
Default Showing and hiding columns

I need help hiding and showing columns based on a cell value. When my
workbook opens column H and I are hidden. Cell C1 is a cell that I have
validation. When the user selects "THIS" in cell C1 I would like column H to
appear. If the user selects "THAT" in cell C1 then I want column I to appear
and column H to be hidden. Can this be done?

T.I.A.

Ed