Compare value of cell in vba

Question

I am trying to compare the value of a cell (always a number) to the iteration variable in a for loop but for some reason vba says this is an invalid call or argument. I am new to vba so any help would be greatly appreciated.

For i = 2 To wb1.Sheets("Development Priority List").Rows.Count

If wb1.Sheets("Development Priority List").Cells("A" & i).Value < i - 1 Then
    wb1.Sheets("Development Priority List").Range("A" & i, "Z" & i).Delete
End If

Next i

Besides what @jbarker2160 mentioned below. There is one more thing. You have to delete the rows in reverse loop else you will miss the rows. Se THIS And one more important point. You are using .Rows.Count That means it will loop though all the rows in the worksheet. Why would you want to do that. I would recommend finding the lastrow using THIS and then looping only till that row. — Siddharth Rout
– Siddharth Rout, Commented Oct 3, 2014 at 15:47
Another Point: Instead of looping, you can also use .Autofilter It will be much faster... :) — Siddharth Rout
– Siddharth Rout, Commented Oct 3, 2014 at 15:48

Mr. Mascaro · Accepted Answer · 2014-10-03 15:42:06Z

2

Your IF statement is incorrect. Change to:

If wb1.Sheets("Development Priority List").Cells(i,1).Value < i - 1 Then

answered Oct 3, 2014 at 15:42

Mr. Mascaro

2,7431 gold badge13 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Siddharth Rout Over a year ago

+ 1 You beat me to it :)

Siddharth Rout Over a year ago

Or replace .Cells with .Range

Collectives™ on Stack Overflow

Compare value of cell in vba

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related