Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look for value in a column and delete
Good day,
I need to look down a column for a certain value and delete all occurances. I have done this by filtering using the code below but not all instances are deleted ? Sub Test() ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2 Selection.AutoFilter Field:=22, Criteria1:="#N/A" Cells(Range("V5").CurrentRegion.Offset(6, 0).SpecialCells(xlCellTypeVisible).Row, 22).Select Selection.CurrentRegion.Select Selection.ClearContents Range("V311:Z311").Clear test2 End Sub Could somebody help with some better code or suggestion. Thanks in advance Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
delete cells column. Delete empty cells | Excel Worksheet Functions | |||
How do I delete everything after a / in a column? | Excel Worksheet Functions | |||
Delete column if .... | Excel Programming | |||
Delete All Rows That Column A value is not in Column A of Sheet2 | Excel Programming |