Easy Excel Macro Question

PinkChick

Hi, I am new to macros and still trying to figure them out, hence the easy question! I have the following macro to delete rows where a certain column is empty. I want to change it to delete if it is empty or 0. See I told you it was easy! Can you use || for or and if so what is the context. Thanks.

Sub Macro1()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual 'pre XL97 xlManual
Dim Rng As Range, ix As Long
Set Rng = Intersect(Range("N:N"), ActiveSheet.UsedRange)
For ix = Rng.Count To 1 Step -1
If Trim(Replace(Rng.Item(ix).Text, Chr(160), Chr(32))) = "" Then
Rng.Item(ix).EntireRow.Delete
End If
Next
done:
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

FSL

You just use OR but you need the complete statement e.g if a=b OR a=c not if a=b OR C (note when typing 'or' it is not case sensitive)

PinkChick

Thanks! That worked :-) So obvious now.

Do you know anything about conditional formatting? I want to make txt bold and red if the cell doesn't say TRUE and is greater than 1. Not working out for me though :-(