Results 1 to 17 of 17

macro to clear values fom 0 (zero) to 0.01

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    macro to clear values fom 0 (zero) to 0.01

    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


     Sub Clear_smallItems()
    With Sheets("Imported data")
    LR = Cells(.Rows.Count, "F").End(xlUp).Row
    For i = LR To 2 Step -1
    If (((.Cells(i, 6).Value) >= 0)) And ((.Cells(i, 6).Value) <= 0.01) Then .Rows(i).ClearContents
    
    
    Next i
    End With
    End Sub

    It would be appreciated if someone could amend my code
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  2. Help with macro to merge/clear duplicate values and leave unique
    By Jharris360 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2012, 11:38 AM
  3. Macro to average imported data, cut, paste, clear values etc
    By mryals in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2011, 02:59 PM
  4. Replies: 4
    Last Post: 04-01-2009, 06:15 PM
  5. [SOLVED] HOW DO I PROTECT VALUES WHEN CREATING CLEAR CONTENTS MACRO?
    By the holster in forum Excel General
    Replies: 1
    Last Post: 02-20-2006, 02:40 PM
  6. Macro to clear combo box values
    By Carpie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2005, 02:05 PM
  7. [SOLVED] Clear values
    By Rene' in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1