Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was given the following code and it works but I need to also add criteria
that is numeric only. When I add numeric only criteria it does not work. Thoughts?? Sub DeleteRows() Dim kpxRow As Long Dim kpxTemp As Long Const Criteria As String = "Y08,Y09" With ActiveSheet kpxRow = .Cells(.Rows.Count, "E").End(xlUp).Row For kpxTemp = kpxRow To 1 Step -1 If InStr("," & Criteria & ",", "," & Left(.Cells(kpxTemp, _ "E").Value, 3) & ",") Then .Rows(kpxTemp).Delete Next End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alphanumeric Sorting - numeric alpha numeric | Excel Worksheet Functions | |||
VLOOKUP with numeric and alphanumeric values | Excel Discussion (Misc queries) | |||
Converting Alphanumeric numbers to Numeric | Excel Worksheet Functions | |||
How to change alphanumeric to numeric | Excel Programming | |||
VBA - Looking to strip alphanumeric from numeric | Excel Programming |