Macro to activate all cells in a range
 

If I have a large matrix of cells that all need to be activated, i
there a macro I can use that will allow me to highlight the range an
activate them all at once

I think someone posted something like this about six months ago

If you know how to write a macro like this, please help

Thanks
Kat
--------
Message sent via www.excelforums.com

Macro to activate all cells in a range
 

Hi Kate

not sure what you mean by "activate" the cells ... could you provide a few
more details as to what you want to achieve.

Cheers
JulieD

"modelergirl - ExcelForums.com"
wrote in message ...
If I have a large matrix of cells that all need to be activated, is
there a macro I can use that will allow me to highlight the range and
activate them all at once?

I think someone posted something like this about six months ago.

If you know how to write a macro like this, please help!

Thanks,
Kate
---------
Message sent via www.excelforums.com

Macro to activate all cells in a range
 

What is your definition of "activate" them. If you highlight them, you have
selected them and one cell will be the active cell (only one cell can be the
activecell).

--
Regards,
Tom Ogilvy

"modelergirl - ExcelForums.com"
wrote in message ...
If I have a large matrix of cells that all need to be activated, is
there a macro I can use that will allow me to highlight the range and
activate them all at once?

I think someone posted something like this about six months ago.

If you know how to write a macro like this, please help!

Thanks,
Kate
---------
Message sent via www.excelforums.com

Macro to activate all cells in a range
 

Sorry, should have clarified

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

Macro to activate all cells in a range
 

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