Satamanster
New Member
- Joined
- Feb 23, 2019
- Messages
- 5
Good morning everyone, let me start by saying that I've looked up for the issue for the past 4 hours and couldn't really find a solution... I tried everything but nothing works. I'm a newbie so please go easy on me...
I have this Worksheet with values on Rows 1-80 and Columns A-C.
It's as straightforward as I'm describing on title...
I want to delete all rows that have a 0 on C
Here is my code:
The weird thing about it is that it deletes some 0's. But leave others... I seriously don't get it. Can you please help? Thanks.
I have this Worksheet with values on Rows 1-80 and Columns A-C.
It's as straightforward as I'm describing on title...
I want to delete all rows that have a 0 on C
Here is my code:
Code:
Dim c As Range
For Each c In sht1.Range("C1:C81").Cells
If c.Value = "0" Then c.EntireRow.Delete
Next c
The weird thing about it is that it deletes some 0's. But leave others... I seriously don't get it. Can you please help? Thanks.