Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Clean data

  Asked By: Mada    Date: Nov 13    Category: MS Office    Views: 469
  

I have a data with about 20 rows and ten columns in the beginning of the
month and I will finish with about 100 rows, but some rows only have
zero values I would like to use a VBA statement that would help to clean
only the rows were exist zero or blank values, Can someone help me?

I have this VBA:

Sub Macro()

Sheets("datareq").Select
Range("A8").Select
Selection.CurrentRegion.Select
Dim rng As Range
For Each rng In Selection
If rng.Value = 0 Then
rng.EntireRow.delete = True
End If
Next
End Sub

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Clean data Or get search suggestion and latest updates.




Tagged: