Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() How can i put these 2 sub into 1 ? Currently to speed up deletion i sort accordingly like Sort by column(12) Run DelPost Sort by column(11) Run DelPre. --------------------------------- Sub DelPost() On Error Resume Next With ActiveSheet.Columns(12) .ColumnWidth = 20 .Replace _ What:="Post", _ Replacement:="#N/A", _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ MatchCase:=False .SpecialCells(xlConstants, xlErrors).EntireRow.Delete End With End Sub Sub DelPre() On Error Resume Next With ActiveSheet.Columns(11) .Replace _ What:="Pre", _ Replacement:="#N/A", _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ MatchCase:=False .SpecialCells(xlConstants, xlErrors).EntireRow.Delete End With End Sub Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selective Deletion within a column | Excel Worksheet Functions | |||
Deletion of rows in a column according to a given criteria | Excel Programming | |||
Selective Column deletion | Excel Discussion (Misc queries) | |||
Selective Column deletion | Excel Discussion (Misc queries) | |||
DELETION OF TRIANGLES FROM COMPLETE COLUMN | Excel Discussion (Misc queries) |