Thank you for trying to help, i appreciate it.

i will try in VB... even tho i'm usless at it.. :P


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829

Hi
as another option try the formula:
=NOT(EXACT(UPPER(A1),LOWER(A1)))

--
Regards
Frank Kabel
Frankfurt, Germany


Maltenrazer wrote:
Thank you for trying to help, i appreciate it.

i will try in VB... even tho i'm usless at it.. :P