if else function

[dshafique]

Hi guys, not too good with if else loops and was looking for a little help. Im trying to run a macro where it checks if the cell below the current one is empty. If so, then delete everything from below that cell. otherwise do nothing

If ActiveCell.Value <> "" Then
        ActiveCell.Offset(1).Select
        Range(ActiveCell, Cells(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column)).Select
        Selection.EntireRow.Delete
    ElseIf ActiveCell.Offset(Is Notempty) Then
        do nothing
       
    End If

 

[Norie]

Can you post the code for the loop?

PS When deleting it's always best to loop 'backwards'/'bottom to top'.

 

[dshafique]

this is basically the code, I forgot to save, and forgot what what was in the else if's body. but this is basically the pseudo code of what it should do