Hi
I need a bit of help with following code.
I am comparing a list on the sd page, if the value on the
sd page is false I want to clear the contents of a row on
the calc (2) page.
I need help to move the activecell down one each time the
macro runs a loop. Then it should work.
Thanks
Jo

Sheets("sd").Select
Range("ac28:ac37").Name = "sdrange"
For Each cell In Range("sdrange")
Sheets("calc (2)").Select
Range("A9").Select
If cell = False Then
Sheets("calc (2)").Select
ActiveCell.EntireRow.ClearContents
ActiveCell.Offset(1, 0).Select
End If

Next