Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activate cell at end of range | Setting up and Configuration of Excel | |||
Using a Macro to find a value in a range and activate it | Excel Programming | |||
use of range and activate | Excel Programming | |||
How to activate array formulas in a range of cells all at the same time? | Excel Programming | |||
range.activate | Excel Programming |