will i need to repeat this for every column?
or is there a loop idea that i can do?
where would i tell it to first do sheet1 and then sheet2


Try this:

If Cells(5,2) < "" Then
If Cells(23,2) = "" Then
Call Msgbox "unable to clear"
End If
End If