| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Snedkeys "{F9}", true does not work
Clara
Could you just use a "Calculate" statement and skip the sendkeys? Ken On Jun 18, 3:52 pm, clara wrote: Hi all, My cal mode is set to manual at start, so in code I use sendkeys "{F9}",True, to force formula to calculate, but it failed until I press F9, I also use "%^F9", neither work.Could you help me to fingure it out? Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SendKeys "{F},true does not work | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Hybrid Mode
