Tami,
You have had several answers to this basic question. Why are you posting
again.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tami" wrote in message
...
hi.
I need help writing a macro that will hide and unhide rows based on the
value in Cell A1. In the below example, If Cell A1=100, rows 3 and 4
would
be hidden and rows 1,2 and 5 would be unhidden. If cell A1=200 then only
row
3 would be shown. Thanks in advance for your help, Tami

Column B
Row 1 100
Row 2 100
Row 3 200
Row 4 300
Row 5 100