Delete cell above me if I am null

[gheyman]

I have been struggling to come up with a code that works for 3 hours now.

I need the code to look across row 6 starting in column F and if the value is null (or I can do < 1) delete the cell right above it.

I cannot look across row 6 to find my LastColumn because values in column 6 stop before values in column five.

So I need to find my last column across row 5 For i = 6 To LastCol

Then do an if statement that reads if (6,i) is null Then
(5,i)clear

PLEASE HELP!! I am completely baffled. Nothing I do is working.

 

[VoG]

If this is related to your earlier thread http://www.mrexcel.com/forum/showthread.php?t=532134 you should perhaps be using Delete, not Clear

For i = lastcol To 5 Step -1
    If Len(.Cells(6, i).Value) = "" Then
        .Cells(5, i).Delete shift:=xlShiftToLeft
    End If
Next i