T

#### Tami

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