Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete columns if 0 | New Users to Excel | |||
Delete columns | Excel Programming | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Delete Columns | Excel Programming | |||
Delete columns | Excel Programming |