Please help..activating array formulas in a range of cells without going cell by cell

[Karenna]

I have already entered array formulas into a range of cells, and the
are different in each cell. Is there a macro that can activate a rang
of cells when I highlight all of them? If I do that now, it copies on
formula to the rest of the cells. Please let me know if there is an
way to do this?

Basically, I'd just like a way around going to each cell and typing F
Cntl-Shift-enter.

(Someone on the other forum posted a macro, but it didn't seem t
work.)

Thanks,
Karenn

 

[Peo Sjoblom]

Maybe you should have posted some of the formulas,
not all array formulas have to be array entered

I hope you know how to "install" the macro

Sub ArrayEnterFormula()
Dim Target As Range
For Each Target In Selection
If Target.HasFormula Then
If Not Target.HasArray Then
Target.FormulaArray = Target.Formula
End If
End If
Next Target
End Sub


select the range of formulas and run the macro

 

[Peo Sjoblom]

Also it is considered bad etiquette to not stay in the original thread..

--

Regards,

Peo Sjoblom

Maybe you should have posted some of the formulas,
not all array formulas have to be array entered

I hope you know how to "install" the macro

Sub ArrayEnterFormula()
Dim Target As Range
For Each Target In Selection
If Target.HasFormula Then
If Not Target.HasArray Then
Target.FormulaArray = Target.Formula
End If
End If
Next Target
End Sub


select the range of formulas and run the macro

 

[Karenna]

Peo,

Thanks very much for the Macro. It worked perfectly.

I'm sorry for not staying within the original thread. I will do tha
next time.

Karenn