Rowan Drummond wrote:
I've read through your other threads and must admit that I am not sure I
totally follow the use of public arrays in your project.

I think what you are asking here is that you want to monitor the cells
in range A1:A209 on a particular sheet. If any of these cells is changed
by a user set each element of the public array indicator to 0. If this
is correct then right click the sheet in question, select view code and
paste the following change event:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long
If Not Intersect(Target, Range("A1:R209")) Is Nothing Then
For i = 1 To 12
indicator(i) = 0
Next i
End If
End Sub

Hope this helps

PS I am assuming from your example that you are using Option Base 1 for
your arrays.

Sinus Log wrote:

Bob Phillips wrote:

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?

There are no formulas in Sheet1, only user data. These data aren't
supposed to change often. But they impact all formulas in the
workbook. The user might want to change the values of about 25 cells
at a time, out of 300, in Sheet1, on an irregular basis. Could leave
them unchanged for years. But then, if the arrays that hold the data
aren't reinitialized, the results would be wrong.

It's enough to set the array indicator() to 0. That would reinitialize
all the other arrays.

The data in Sheet1 are included in the range a1:r209 .

Fantastic, it's exactly what I needed. Many thanks. And yes,
I'm using Option Base 1.

I've read through your other threads and must admit that
I am not sure I
totally follow the use of public arrays in your project.

It's probably because I have not been initiated to Excel,
and I don't use the proper words. I am a self-made
123-veteran, if I may say so. But you got everything I meant
all right. Thanks again.