View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sinus Log Sinus Log is offline
external usenet poster
 
Posts: 22
Default To detect changes in a worksheet

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