L
LLee2
Hello,
I have a file with 3 worksheets. I assigned a macro to a combo box on
sheet1. The macro only controls sheet2. How can I modify this macro so it
works for both sheet2 and sheet3? Sheet2 and sheet3 are identical.
Sub RwHide()
Dim RwCnt As Integer
For RwCnt = 8 To 138
If Range("N" & RwCnt) = 0 Then
Range("N" & RwCnt).EntireRow.Hidden = True
End If
Next
For RwCnt = 8 To 138
If Range("N" & RwCnt) <> 0 Then
Range("N" & RwCnt).EntireRow.Hidden = False
End If
Next
End Sub
Thanks a lot,
LLee
I have a file with 3 worksheets. I assigned a macro to a combo box on
sheet1. The macro only controls sheet2. How can I modify this macro so it
works for both sheet2 and sheet3? Sheet2 and sheet3 are identical.
Sub RwHide()
Dim RwCnt As Integer
For RwCnt = 8 To 138
If Range("N" & RwCnt) = 0 Then
Range("N" & RwCnt).EntireRow.Hidden = True
End If
Next
For RwCnt = 8 To 138
If Range("N" & RwCnt) <> 0 Then
Range("N" & RwCnt).EntireRow.Hidden = False
End If
Next
End Sub
Thanks a lot,
LLee