View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,alt.comp.lang.vba
Zachary Harrison Zachary  Harrison is offline
external usenet poster
 
Posts: 2
Default Formulas not filling in without F2+enter

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