I think you might want to show your code. The change in the worksheet won't
change the value in the array. But it is likely that your procedure that
loads the array stops before the cell changes, and re-starting will
re-initialise the code.

Give the code and a detailed explanation .

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hke" wrote in message
...

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