Filter words and delete rows (column header..
Closed
Lilly
-
Nov 24, 2010 at 12:36 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2010 at 09:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2010 at 09:47 AM
Related:
- Filter words and delete rows (column header..
- How to delete whatsapp account without login - Guide
- How to delete whatsapp account without phone - Guide
- Delete snapchat - Guide
- Black and white filter - Guide
- Yahoo search history delete - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 25, 2010 at 09:47 AM
Nov 25, 2010 at 09:47 AM
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