Hiding A Row

Dim cell as Range
rows.Hidden = False
for each cell in Range("C1:C200")
if cell.Value = 3 then
rows(cell.Row).Hidden = True
exit for
end if
Next

--
Regards,
Tom Ogilvy

"Dan G." <dgesshel@socal.rr.com> wrote in message
news:uHW4LKtjFHA.3756@TK2MSFTNGP15.phx.gbl...
> Hello.
>
> I am trying to hide a row based on a value in a cell within the row. I
> need this to take place as the sheet re-calculates after a different
> selection is made from the Forms combo-box.
>
> Not sure why I'm having issues, as this should be pretty
> straightforward.
>
> Any help would be greatly appreciated.
>
> Thanks.
>
> Dan
>
> *** Sent via Developersdex http://www.developersdex.com ***

I understand the code, and either would suffice. The problem I have is
having it execute upon a change in the drop-down.

Currently values re-calculate on the sheet in a series of INDEX
formulas. If you activate another cell on the sheet it works fine. If
you only change the drop down box, and don't select another cell, the
code does not execute.

What do you recommend?


*** Sent via Developersdex http://www.developersdex.com ***

You might try using the change event instead of the selection change event.

Of course some drop downs have their own events and the one to look for
would most likely be the exit event (or the change event but this one
activates each
time a single character is typed into the drop down)

--
steveB

Remove "AYN" from email to respond
"Dan G." <dgesshel@socal.rr.com> wrote in message
news:%23h13e37jFHA.1416@TK2MSFTNGP09.phx.gbl...
>
> I understand the code, and either would suffice. The problem I have is
> having it execute upon a change in the drop-down.
>
> Currently values re-calculate on the sheet in a series of INDEX
> formulas. If you activate another cell on the sheet it works fine. If
> you only change the drop down box, and don't select another cell, the
> code does not execute.
>
> What do you recommend?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***