Delete all Columns with a certain value
Here is another one if you want to try different techniques.
Sub gifDel()
For Each Column in ActiveSheet.Columns
Set c = Cells.Find("c:/bitmaps/exclaim.gif", LookIn:=xlValues)
If Not c Is Nothing Then
fRng = c.Address
Range(fRng).EntireColumn.Delete
End If
Next
End Sub
" wrote:
Hello All,
This is a real newbie question and there have been a few posts with
code but they don't work for me.
I need to look for columns that have the following in its cell: "c:/
bitmaps/exclaim.gif"
If there is an occurence of this in the cell, delete the column and
all other columns that have this value in it.
Can anyone help me with this?
|