F2 Function key
 

Hi

In one of my excel sheet column A i have a set of funtions, but the function
will work only when i press F2 and ENTER keys in each rows , the problem is i
have 25000 rows.

is it possible to create macro code to press F2 and ENTER keys, Inspite of
me doing it mannually

F2 Function key
 

From VBA you can use Application.CalculationFull

If this post helps click Yes
---------------
Jacob Skaria


"Ranjith Kurian" wrote:

Hi

In one of my excel sheet column A i have a set of funtions, but the function
will work only when i press F2 and ENTER keys in each rows , the problem is i
have 25000 rows.

is it possible to create macro code to press F2 and ENTER keys, Inspite of
me doing it mannually