Is their a function or way to use the UPPER function to test if the contents
on a cell are all Upper case?

Alternatively if someone has a macro to do so I could copy I would appreciate.