Do you want to clear all of the array on every change (probably not), or
what? Do you have a limited size data range that will be affected in this
way?

--

HTH

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


"Sinus Log" wrote in message
...
I have defined public arrays to keep in memory user data
entered in Sheet1. I need to have these data erased from
memory as soon as new data is entered in that worksheet. For
that, I can use something like:

public function f()
?
for i=1 to 12
indicator(i)=0
next i
end function

I don't have the knowledge to write the missing statement. I
suppose it involves Worksheet_Change. Can someone help me
with that, please ?
Thanks