Hi Ivory Kitten,

It's odd, I have no other codes, its working fine now. The case bit was
working and the hide/unhide row part was not. But it is now!?

I am glad that you have got it working.

how do you change the hide/unhide so that it hides when empty or
a certain value?

Change:

Rows(19).EntireRow.Hidden = IsEmpty(rng.Value)

to

Rows(19).EntireRow.Hidden = Not IsEmpty(rng.Value)

---
Regards,
Norman