Hello Friends,
I have a set of data which contains shipment records. I have to hide the rows where Column O
shows the status of the Shipment.
I am using the below mentioned code to hide rows based on Column O
Is there any other way out (code) that can provide the desired result a bit fast or can we
change the code to make it work fast
Any help would be appreciated
Regards,
Humayun
I have a set of data which contains shipment records. I have to hide the rows where Column O
shows the status of the Shipment.
I am using the below mentioned code to hide rows based on Column O
PHP:
Private Sub CommandButton1_Click()
For a = 3 To 500
If Worksheets("RO").Cells(a, 15).Value = "Shipped" Then
Worksheets("RO").Rows(a).Hidden = False
End If
If Worksheets("RO").Cells(a, 15).Value = "In Progress" Then
Worksheets("RO").Rows(a).Hidden = True
End If
Next
End Sub
PHP:
Private Sub CommandButton2_Click()
For a = 3 To 500
If Worksheets("RO").Cells(a, 15).Value = "Shipped" Then
Worksheets("RO").Rows(a).Hidden = True
End If
If Worksheets("RO").Cells(a, 15).Value = "In Progress" Then
Worksheets("RO").Rows(a).Hidden = False
End If
Next
End Sub
PHP:
Private Sub CommandButton3_Click()
For a = 3 To 500
If Worksheets("RO").Cells(a, 15).Value = "Shipped" Then
Worksheets("RO").Rows(a).Hidden = False
End If
If Worksheets("RO").Cells(a, 15).Value = "In Progress" Then
Worksheets("RO").Rows(a).Hidden = False
End If
Next
End Sub
Is there any other way out (code) that can provide the desired result a bit fast or can we
change the code to make it work fast
Any help would be appreciated
Regards,
Humayun