The only times you'll need to confirm with CONTROL+SHIFT+ENTER are when
you first enter the formula and whenever you edit the formula.

Hope this helps!

nrussell Wrote:
ah so thats an array formula. Sorry I've not used them in the past so
this may sound dumb but would you have to confirm them each time you
open the workbook or just once before you protect them?

Thanks Domenic, sorry to keep bugging you but hey you can't learn
unless you ask :)

-Joe


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=374639