Posted to microsoft.public.excel.programming

Tim[_29_]

external usenet poster

Posts: 8

Code to hide rows based on cell contents

Hi

I have a cost model, you have to answer a set of
questions. The set of questions depends on which of 3
options is selected in a cell (i've used a data
validation list).
I'm new to VB in Excel and I need something like this:

If Selection Cell = option A
Hide Rows 6-9
If Selection Cell = option B
Hide Rows 10-18
Else
Show all of them

Any suggestions?
TIA
tim

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
code to unhide tabs based on cell contents	pat67	Excel Worksheet Functions	7	August 26th 11 12:43 AM
hiding rows based on cell contents	Jason M	Excel Discussion (Misc queries)	1	October 30th 06 04:30 PM
hide rows based on cell value	dummster	New Users to Excel	1	February 15th 06 11:37 PM
hide rows based on value in cell	dummster	Excel Discussion (Misc queries)	0	February 15th 06 03:27 PM
Add Rows based on Cell contents	Doug Manning	Excel Discussion (Misc queries)	0	September 16th 05 07:01 PM

All times are GMT +1. The time now is 04:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us