V
Vincent A. Somoredjo
Hallo,
Can you please provide some assistance?
I have the following code in a worksheet (Register), if the value in Column
H is "Closed" I am hiding the row in the WorkSheet (Register). At the same
time I want to copy the hidden row to another sheet (Closed Issues).
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lngRow As Long
Application.ScreenUpdating = False
For lngRow = 5 To lastRow
If Range("H" & lngRow).Value = "Closed" Then
Rows(lngRow + 0).Hidden = True
Else
Rows(lngRow + 0).Hidden = False
End If
Next
Application.ScreenUpdating = False
End Sub
Can this be done?
Thanks in advance for your support.
Can you please provide some assistance?
I have the following code in a worksheet (Register), if the value in Column
H is "Closed" I am hiding the row in the WorkSheet (Register). At the same
time I want to copy the hidden row to another sheet (Closed Issues).
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lngRow As Long
Application.ScreenUpdating = False
For lngRow = 5 To lastRow
If Range("H" & lngRow).Value = "Closed" Then
Rows(lngRow + 0).Hidden = True
Else
Rows(lngRow + 0).Hidden = False
End If
Next
Application.ScreenUpdating = False
End Sub
Can this be done?
Thanks in advance for your support.