macro to clear values fom 0 (zero) to 0.01

[Howardc1001]

I have tried to write code to clear values from 0 to 0.01 in Col F from row 2 onwards

The macro clearing all data in the same row as where 0 to 0.01 in in Col F

Please Login or Register  to view this content.

It would be appreciated if someone could amend my code

[PCI]

See next code

Please Login or Register  to view this content.

[Marc L]

According to your attachment a beginner starter demonstration :

Sub Demo1()
         Dim Rg As Range
    For Each Rg In Sheet1.UsedRange.Columns(6).Cells
          If Rg.Text <= 0.01 Then Rg.ClearContents
    Next
End Sub 

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[Howardc1001]

Thanks for the help Marc. I made one small change

Please Login or Register  to view this content.

[Sintek]

Please Login or Register  to view this content.

[Howardc1001]

Hi PCI

Thanks for the help. I only want to clear values in Col F from row2 where the values range from 0 to 0.01

Your code clear the values in Columns A:F where 0 to 0.01 appears in Col F

I have attached the file after running your code

[PCI]

Your code clear the values in Columns A:F where 0 to 0.01 appears in Col F

Yes because your original was doing like that and perhaps was it the specifications.
But now you have a lot to play with ...!

[Sintek]

Thanks for the help Marc. I made one small change

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Does exactly the same...With your info...

PS...One should avoid sheet loops as much as possible....Filtering is just as effective if not more...as per post 5

[Howardc1001]

Thanks for your input Sintek

[Sintek]

I notice, from most of your other posts that you always opt for looping solutions...Any reason why you prefer loops over Filtering...

[PCI]

Any reason why you prefer loops over Filtering...

Perhaps more simple to prepare and certainly the first reflex ... a new target for 2020

[PCI]

For the fun a remake with filter

Please Login or Register  to view this content.

[Sintek]

For the fun a remake with filter

Too late...see post 5

[Howardc1001]

Thanks for the update with Autofilter

[Howardc1001]

Hi Sintek

The reason why I use looping over filtering is that I am more familiar with this, but will start use autofiltering as much quicker

[Sintek]

Understood...tx for clarification...Enjoy your journey...Right platform for learning...

[PCI]

Too late...see post 5

Perhaps not, when already exist autofilter with selection ...!