If your 72 cells are in a single row or column (or rectangular range of
cells), you can name the range and then use the Intersect function to
check if the changed cell is in the named range.

If your 72 cells aren't in a simple row, column or rectangular array,
and if there the calculation you need to perform is the same, regardless
of which cell changes you might consider a Case Select with the
calculation in its own function or subroutine - which would reduce the
amount of code to write.

Also, you might (with adequate comments added to the posts in this
thread which indicate you have moved your question) cross-post your
problem over to the Excel VBA Programming sub-group where some
higher-power experts hang out...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112280