VBA to clear contents of the cell in a column of data in a cell starts with specific word.

**winmaxservices1** · 01-03-2015, 07:57 AM

VBA to clear contents of the cell in a column of data in a cell starts with specific word.

Have to clear the contents of all those cells in a coloumn which starts from "Property ID"
Have attached the excel file where data and needed result is mentioned.

**Faridwahidi** · 01-03-2015, 08:22 AM

HI winmax,

You may try this,

Sub ClearContents()
Dim rng As Range

    For Each rng In Range("A2:A24")
    
        If Left(rng, 11) = "Property ID" Then
            rng.Value = ""
        End If
    Next rng
End Sub

Please add my reputation if the above code has solved your problem

**HaHoBe** · 01-03-2015, 08:23 AM

Hi, winmaxservices1,

use the Autofiloter and "Starts with" to filter and delete the rows/entries manually.

As your data shows empty cells next to the searched words you may like to use

Sub EF1058181()
On Error Resume Next
Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

Sub EF1058181_2()
On Error Resume Next
Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks).Offset(0, -1).ClearContents
End Sub

Ciao,
Holger

**sktneer** · 01-03-2015, 08:25 AM

You may try this..

Sub ClearCells()
With Range("A:A")
    .AutoFilter field:=1, Criteria1:="Property ID*"
    .SpecialCells(xlCellTypeVisible).Cells.ClearContents
    .AutoFilter
End With
End Sub

VBA to clear contents of the cell in a column of data in a cell starts with specific word.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA to clear contents of the cell in a column of data in a cell starts with specific word.

Re: VBA to clear contents of the cell in a column of data in a cell starts with specific w

Re: VBA to clear contents of the cell in a column of data in a cell starts with specific w

Re: VBA to clear contents of the cell in a column of data in a cell starts with specific w

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Clear contents in specific cell and the cells in the next 2 columns to the right

[SOLVED] move down column and for every blank cell, clear contents of cell to the left

[SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty

[SOLVED] remove cell contents if contains certain word in a specific column

Delete rows or Clear contents below a specific word is found in Column A

Bookmarks

Bookmarks

Posting Permissions