Results 1 to 2 of 2

Clear Cell Contents Based on Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Clear Cell Contents Based on Criteria

    I have column M that holds an if formula for a Yes/No return. If the cell is yes, I want a loop to clear the contents of the cell in the same row, but one column before it (column L). Here is my loop now:

        Range("A16").Select
    
        Do Until ActiveCell.Offset(0, 1) = ""
    
            ActiveCell.Range("A1:L1").Select
    
            If ActiveCell.Offset(0, 12) = "Yes" Then
    
                 Activecell.offset(0,11).clearcontents
    
            Else: ActiveCell.Offset(1, 0).Select
    
            End If
    
        Loop
    Any suggestions?
    Last edited by jeffreybrown; 12-14-2012 at 01:40 PM. Reason: Please use code tags...Thanks.

Thread Information

Users Browsing this Thread

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

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