Thread: Arrays question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Arrays question

Hello Eli,

You can store your second array in a worksheet and check via the
Worksheet_Change event whether the Target parameter intersects with
your array cells.

Or you keep a copy of your second array in memory and whenever you
need to know whether its changed you apply an item-wise check.

Regards,
Bernd