The If-Then operator returns a value. However, I would like to take an action. I have a worksheet which has a column with numerical data in it. I wish to start at the first row in that column and test to see if the value in the cell is within a defined range. If it is then I wish to move the cursor to the next row (in the same column). If it is not within the range then I wish to delete the present row. Can someone clue me in on how to do this. Thanks in advance for any help.

I have figured out the problem. Simple, really. I was using the macro feature which will not allow the If-Then operator to behave as I wanted. I had to program the feature directly into the Visual Basic Editor.

Sorry for jumping the gun.