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

  • Thread starter Thread starter Karenna
  • Start date Start date
K

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
 
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
 
Also it is considered bad etiquette to not stay in the original thread..

--

Regards,

Peo Sjoblom

Peo Sjoblom said:
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
Click to expand...
 
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
 
Back
Top