I tried using the Len function, but it's the same :(
Because, i'll be going back to the 'select case', which is giving m
the problem with the annoying error message popping up


Dick Kusleika Wrote:
silvest

I'm not familiar with a "function box". What is that exactly?

One thing you could (depending on the above) is

If Len(XX) = 5 Then
Select Case XX
etc..



--
silves
-----------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=26731