help with a loop!!!

[seriouslystuck]

Hi all

I have wrote a simple vba loop as below. Im wondering how to get it to stop at last row?

Range("F4").Select
Do Until Selection.Value = ""
If Selection.Value = Range("EP15") Then
Selection.Value = Range("EP4")

Else Selection.Offset(1, 0).Select
End If
Loop

Thanks

 

[jim may]

Change ALL 4 references of "Selection" to "Activecell"; Will that work for you?

 

[seriouslystuck]

Hi jim

Thats seems to work fine. If I wanted to use the loop to look in a cell then another cell in the row and depending on the results delete the row can I just add and into the if?

Thanks

 

[jim may]

Sure, an If within an If can be the way to go...