Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get this code to delete every row if the value in
column B begins with "X1". I'm getting a syntax error any help would greatly be appreciated Error here - Select Case Left((c, 2), 2) Complete code: Sub DeleteRowCase() Dim c As Long Dim LastRow As Long Application.ScreenUpdating = False LastRow = Range("C65536").End(xlUp).Row For c = LastRow To 2 Step -1 Select Case Left((c, 2), 2) Case Is = "X1": .EntireRow.Delete Next c End Select Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
how to use select case | Excel Programming | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Case Select | Excel Programming |