hide rows ?

is it possible to hide rows with VB??
let's say
if a specific cell = a then hide
if b, then unhide etc???
do i use the module or the worksheet to enter the code?

what coding do i need?

consider the fact that i am a newbie!!!!!!..i am just getting started with VB.. need to gain an understanding of what happens and how!

pls help

How do you wabnt to trigger this, on a cell change or run a macro to hide/unhide the rows?

on a cell change. ( i have put a list validation in a cell...so when smone chooses from the list i want the format to chng)
also i am trying to figure out some part of the coding..but i think i am doing stupid things!

I went to Sheet1 which is the one with the cell and i named the sub formatchg.. (maybe that is wrong too)

then i attempted to chng a cell once the cell has a specific string in it! ( in the meanwhile it should hide some rows...but that s step 2)

so my wrong effort

Please Login or Register  to view this content.

i am laughing myself because i know things are not that simple!

Please use Code tags when posting code in the Forum.

You do not enter macros in the worksheet module.

Your code example doesn't hide any Rows.

You do not enter range references like this

Please Login or Register  to view this content.

Use either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.