Is there a way to set particular cells so that no matter what is typed
into them it will always apear in upper case. I realise you can do this
if you set the column next to it to read =upper([cell ref]) but i dont
want to do it this way is there an alternatve perhaps via code im not
sure


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=545914