the cells are linked to other cells. their status is empty, unless they
change. when they do they trigger a worksheet calculate and go
immediately back to empty. problem is, i have some 50 of them and when
a work sheet calculate is triggered at times i dont know which cell
does trigger it.

problem is, i have tried a selection change code for all the 50 cells
but this make the machine very slow and clashes with other macros.

ideally i think i would need to create a function (add-in). hmmm

BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=386781