Hi All,
having a little trouble trying to do the following.
A report is run, based on the values between A7:A31
This then populates info into cells B7:I31
However, if there is no value in one of the cells at the end, eg. A:28, A29, A30, A31 (the cells are sorted in order first, so you wouldnt get a random empty cell inbetween values) then it should just clear the contents for that entire row, so that #N/A, doesnt show.
please note i only want to clear out the cell content, not delete out an entire row.
this is something like what i need i think...
http://www.mrexcel.com/forum/showthread.php?t=307244&highlight=delete+empty+row
having a little trouble trying to do the following.
A report is run, based on the values between A7:A31
This then populates info into cells B7:I31
However, if there is no value in one of the cells at the end, eg. A:28, A29, A30, A31 (the cells are sorted in order first, so you wouldnt get a random empty cell inbetween values) then it should just clear the contents for that entire row, so that #N/A, doesnt show.
please note i only want to clear out the cell content, not delete out an entire row.
this is something like what i need i think...
Code:
Sub ColorEmpty()
LastRow = Range("A65536").End(xlUp).Row
For i = 1 To LastRow
If IsEmpty(Cells(i, 5)) Then
Cells(i, 5).EntireRow.Delete
End If
Next i
End Sub