Macro to check values based on certain text

[Admin]

Hi

Use this formula.

If Evaluate("sum(sumif(" & myRange.Address(external:=1) & ",{"">0.00001"",""<0.0001""}))") <> 0 Then

[Howardc]

Hi

Use this formula.

If Evaluate("sum(sumif(" & myRange.Address(external:=1) & ",{"">0.00001"",""<0.0001""}))") <> 0 Then

Thanks for the help, it would perfectly now.

I would like to exclude anothetr sheet when checking varianced called "Months". How do I include this. Tried, but could not get it to work

For Each sh In Worksheets
If UCase(sh.Name) <> "CONSOLIDATED" Then


cAddress = ""

[Howardc]

Hi Admin

Managed to sort out the code

If UCase(sh.Name) <> "CONSOLIDATED" And UCase(sh.Name) <> "MONTHS" Then
cAddress = ""

Regards

Howard