Automate F2->"enter"

[kkjensen]

I need to automate the equivalent of pressing "f2" (to edit a cell) and then "enter" to accept whatever was already in it.

I've got some custom functions in a sheet that I can't change (VB all locked) and if these functions reference a file that isn't open they seem to lock up and quit working until I select them and hit F2->Enter.

 

[kkjensen]

Got it!

temp = ActiveCell.FormulaR1C1
ActiveCell.FormulaR1C1 = temp

You're amazing! ray:

 

[kkjensen]

I'm feeling a bit schizo' doing this by myself but I have another question to ask...


Does anyone know how I'd go about looping through all the cells (let say the top 200 rows for speed) of each sheet in a workbook?