Showing and hiding columns
 

use the change event and check if the Target is cell C1. If so, then take
the appropriate action.

--
Regards,
Tom Ogilvy

"BatMan" wrote in message
...
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

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