Forum Discussion
ALASKANBULLWORM
Aug 16, 2021Copper Contributor
VBA delete loop only deletes one line
Hello, I'm trying to create a macro that deletes all lines in a workbook having specific values, here is my code: Sub DeleteRowswithSpecificValue()
Dim cell As Range
For Each cell In Ran...
NikolinoDE
Aug 16, 2021Platinum Contributor
If you don't necessarily want to do it with VBA, an alternative with a filter could also help.
Example in the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
- ALASKANBULLWORMAug 16, 2021Copper ContributorNikolinoDE
Thank you for your reply. I am aware of this option, I am trying to create a large series of these macro functions to transform these data files regularly, more quickly, and for individuals I work with who have less knowledge of excel.