Filter words and delete rows (column header..
Closed
Lilly
-
24 Nov 2010 à 12:36
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2010 à 09:47
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2010 à 09:47
Related:
- Filter words and delete rows (column header..
- How to delete column in word - Guide
- Filter unknown senders android - Guide
- Delete my whatsapp account without app - Guide
- Snapchat black and white filter - Guide
- Front panel audio header - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
25 Nov 2010 à 09:47
25 Nov 2010 à 09:47
Hi Lilly,
Try this code:
There are other structures for doing this, but I really like this one.
You can record a macro, apply filter, show only rows containing "stock" and then delete those rows, stop recording and take a look at the code excel created for you.
Best regards,
Trowa
Try this code:
Sub test()
Set MR = Range("K2:K100")
For Each cell In MR
If cell.Value = "stock" Then cell.EntireRow.Delete
Next
End Sub
There are other structures for doing this, but I really like this one.
You can record a macro, apply filter, show only rows containing "stock" and then delete those rows, stop recording and take a look at the code excel created for you.
Best regards,
Trowa
