set rng = Range("B9:F30")
rng.formula = "=trunc(rand()*100+1)"

change the formula to the one you want activated.

--
Regards,
Tom Ogilvy




"modelergirl - ExcelForums.com"
wrote in message ...
Sorry, should have clarified.

I am trying to activate matrix formulas in the cells, which would be
done cell by cell using F2+Shift+Enter.
---------
Message sent via www.excelforums.com