| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
![Ranjith Kurian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
