vba - autohide rows in excel based on condition -

i have found several responses similar questions, can't make work life of me. trying automatically hide rows based on input in cell. have data in columns thru j, , want autohide rows in input value in column k. can done, @ wit's end trying vba macros work!

any appreciated.

thanks!

all need worksheet change event in sheet. put code in code section of sheet

private sub worksheet_change(byval target range)     if target.column = 11 ' column k column number 11         target.entirerow.hidden = true     end if end sub 

when change value in cell in column k hide entire row.
if want work in usedrange can edit code work way well.