- Sep 8, 2010
Hey, I need to Hide Row's 34-47 Based on a summed Value in Y34 -Y47. IE if Y34 = 0 then Row 34 is hidden, if Y35 = 0 then 35 is hidden Ive tried this with a couple different code and it keeps erroring. Error 425
Does Any one Have a simple way to Hide the rows? They will always be 34-47 and Based on Y34 -Y47.
Private Sub Worksheet_Calculate(ByVal Target As Range) If Target.Address = "$Y$34" Then If IsNumeric(Target) Then Rows(34).EntireRow.Hidden = (Target.Value = 0) End If End If End Sub