Macro to activate all cells in a range

  • Thread starter Thread starter modelergirl - ExcelForums.com
  • Start date Start date
M

modelergirl - ExcelForums.com

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
 
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
 
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).
 
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
 
set rng = Range("B9:F30")
rng.formula = "=trunc(rand()*100+1)"

change the formula to the one you want activated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Run macro from active workbook whose name keeps changing 20
Macro to "find" the next empty cell in a range 2
copy a range from active cell 6
Execute macro when active cell is in a defined area 3
Loop macro in selected range 8
How do I change the active cell in a non contiguous range or selection? 0
Combine 2 columns in a dynamic range into one 7

Back
Top