If I set the first element in an array equal to the value of cell A1
(say it is 5) and I later clear the contents of A1, the value of first
element in array then becomes 0 (in case array is integer)

Is there a way to make sure the Array values are left unchanged by
"actions" on the sheet?


--
hke
------------------------------------------------------------------------
hke's Profile: http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread...hreadid=314310