Macro to check values based on certain text

[Howardc]

Hi Admin

Managed to sort out the code

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

Regards

Howard