Hiding columns when a particular cell is empty.

dunk · Apr 10th, 2002, 07:07 AM

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 · Apr 10th, 2002, 09:10 AM

Anybody help??

giacomo · Apr 10th, 2002, 09:16 AM

paste this into the worksheet_SelectionChange sub:

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

hope that helps
giacomo

dunk · Apr 10th, 2002, 09:41 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 07:07 AM	#1
dunk New Member Join Date: Feb 2002 Posts: 30	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

Apr 10th, 2002, 09:10 AM	#2
dunk New Member Join Date: Feb 2002 Posts: 30	Anybody help??

Apr 10th, 2002, 09:16 AM	#3
giacomo Board Regular Join Date: Feb 2002 Posts: 1,802	paste this into the worksheet_SelectionChange sub: Columns(2).Hidden = IsEmpty(Range("b7").Value) hope that helps giacomo

Apr 10th, 2002, 09:41 AM	#4
dunk New Member Join Date: Feb 2002 Posts: 30	A big thank you. Its only easy if you know how!!