Within VB, how do you reference the cells that your array formula i
entered in?

e.g. Range A1 to A10 has an array formula entered into it. Within th
code, I need to identify that this covers 10 cells.

NB 'Selection.Count' is not valid since this only works at the time th
user enters the array formula, and not on subsequent recalcs when othe
cells may be active

--
mayr
-----------------------------------------------------------------------
mayre's Profile: http://www.excelforum.com/member.php...fo&userid=2760
View this thread: http://www.excelforum.com/showthread.php?threadid=47129