Macro to check values based on certain text

[Howardc]

Hi Admin

Attached please find sample data. When activating the macro and there is only one value being a debit in the same row as the text check, it is not shown in the message box. All values that are not zero, except values that are more or less than 5 dicimal places are to be shown-see sample data, B52, which is not shown in message box

[Admin]

Hi

Just remove the ABS part from the formula.

[Howardc]

Thanks for the help,I removed the ABS part, but the value in cell B52 (-20) is not shown in the message box. If this value is positive, the row number will be displayed ijn the message box

If I have 20 in B52 and -20 in C52 , then B52 & C52 will be displayed in the message box

It would be appreciated if you could correct this

[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