Keyboard Macro

[MikeDBMan]

I wish to have a macro that just does this:

Hits F2 (for cell edit)
Then Hits enter key

I can't record a macro that does that. It edits the formula. Suggestions?

 

[Joe4]

Why are you trying to do this?
Do you have formulas that wwere entered as text and trying to convert them to formulas so they will calculate?

 

[Joe4]

If that is the case, here is a simple macro that will convert the ActiveCell to a formula. You can then assign this macro to a keyboard shortcut, if you like:

Sub ConvertToFormula()
    ActiveCell.NumberFormat = "General"
    ActiveCell.Formula = ActiveCell.Text
End Sub

 

[MikeDBMan]

I am trying to do this because There are #Value in the cells and calculating does not recalculate it to a value. But Editing and hitting enter does.

 

[Joe4]

I am trying to do this because There are #Value in the cells and calculating does not recalculate it to a value. But Editing and hitting enter does.

Why do you have a #Value error?
Is your AutoCalc shut off? If so, just turning it back on of hitting F9 to recalculate should take care of the problem.

 

[MikeDBMan]

It is not that simple. There is an upload VBA program to upload data into an SAP accounting package called BPC. When connected to BPC, the #Value was somehow displaying even though there is a valid formula in the cell. But if I manually update them the value "reappears" when I am not using the BPC upload. Hope this makes sense.

 

[Joe4]

What happens if you press F9 to recalculate?
Does it fix it?

 

[MikeDBMan]

If I press F9 NOTHING happens.

 

[Joe4]

Can you post one of these formulas returning that error?

 

[MikeDBMan]

Sure. It is a fairly simple formula:

=-1*(SUMIF('Revenue-Prod'!$A$8:$A$20,'BPC Submit Ivy'!$M40,'Revenue-Prod'!D$8:D$20))+'Revenue-Prod'!D91