Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax error in code
I'm using this code in an existing macro to keep only rows with "F800" in
column J. All other rows are being deleted. The spreadsheet varies in length every day so there is no end specified. The syntax error I'm receiving in my code is on this line: If StrComp(Cells(RowNdx, "J"), "F800", vbTextCompare) < 0 Then Thanks for your help. With Selection Dim LastRow As Long Dim RowNdx As Long LastRow = Cells(Rows.Count, "J").End(xlUp).Row For RowNdx = LastRow To 1 Step -1 If StrComp(Cells(RowNdx, "J"), "F800", vbTextCompare) < 0 Then Rows(RowNdx).Delete End If Next RowNdx End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error: syntax error or access violation | Excel Programming | |||
runtime error: syntax error or access violation | Excel Programming | |||
What's the syntax error with this SendKeys code? | Excel Programming | |||
Syntax Error in VLOOKUP Code | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |