I think it has to do with certain assumption excel makes during runtime
If you try to place a non Compatable value in a variable. It will tr
to convert that variable into the type required and place the value i
it. However depending on what goes on with the variable beforehand i
may or May not be able to do this. When you declare a variable
Dim strtest as Strin
You DIMension up an area of memory in a "format" to receive strin
type. BUT strtest ISNT yet a string. This is decided when it gets i
first value IE strtest = 2 or StrTest = "a" Depending on what you d
from then on determines whether you get an error. It has something t
do with the fact that a String data type is really just a singl
dimension array of characters
While excel will try to work around your errors there are times when i
will just throw up its hands and go "Sod you Im Not Dealing with thi
Rubbish! YOu FIX it!!" IE you get a runtime erro
From memory.....It been awhil
--
Willo
-----------------------------------------------------------------------
Willot's Profile:
http://www.excelforum.com/member.php...fo&userid=3516
View this thread:
http://www.excelforum.com/showthread.php?threadid=54973