Auto. Hide & Unhide Rows based empty rows or rows with any value!!!

[MarkReddell]

Hello everyone! I really need help in auto. hide & unhide rows 5:3666. This worksheet is named Feed Sheet & it is also a pivot table. I have a report starting in row 3667 from the data above in the rows 5:3666. I need for any rows from 5 to 3666 to hide/unhide based on any data entries in those rows from column a:z of any value . I'm hopeful that there is a fix for this issue!!! Thanks very much for any help!!!

 

[Copan1795]

Hello,

Try this where I put Down you can cahnge that to whatever you want


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows("5:3666").Hidden = Range("3667").Value = "Down"


End Sub

 

[MarkReddell]

I'm not sure how to make this work! I tried with no success. I need for each row to auto hide or unhide based on whether or not the row is empty or not. i.e.: if rows 5:25 have info of any kind; those rows would auto unhide & rows 26:3666 would then auto hide. etc. Is there a answer for this problem??? Thanks again for your help!!!