View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_29_] Tim[_29_] is offline
external usenet poster
 
Posts: 8
Default 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