Hiding columns when a particular cell is empty.

[dunk]

Hi,
I'm looking for a little piece of code to do the following:

IF cell b7 is empty THEN
hide column b
END IF

Any help would be greatly appreciated

dunk

 

[dunk]

Anybody help??

 

[giacomo]

paste this into the worksheet_SelectionChange sub:

Columns(2).Hidden = IsEmpty(Range("b7").Value)

hope that helps
giacomo

 

[dunk]

A big thank you.
Its only easy if you know how!!