Try something like

Dim Rng As Range
For Each Rng In Selection.SpecialCells(xlCellTypeFormulas)
If Rng.HasArray = True Then
Rng.FormulaArray = Rng.Formula
Else
Rng.Formula = Rng.Formula
End If
Next Rng



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zachary Harrison" wrote in message
ups.com...
Hi all-

I am using vba code to setup a few blph() functions in a
workbook. If
you are not familiar with bloomberg or this function, please
read on as
my problem is more general!

After my code has finished running the formulas don't execute
unless I
goto the cell and hit F2 then enter. Pressing F9 for calculate
does
not do the trick.

I tried recording this action of F2+enter but the macro just
shows
selecting the cell and setting the formula to what I already
had it at.

Is there a way to simulate this F2+enter in vba code? Any
other ideas?

Thank you,

Zach