| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function does not work in a cell. Please Help
I have a program that fill Excell 2000 template with data and functions.
Every function works and shows the right result however one user defined function show only #NAME? instead of result. When I click on the sell the function =+calculateNasdRegChargePercent(Z4) appears. I click on a red sign in the middle of the formula bar between 'x' and '=' and the function evaluates itself into meaningfull number. The argument in cell Z4 is a function itself that works OK. Can anybody help me to force the function to evaluate itself without manual interaction using VBA. I already used Calculate function with partial success. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function does not work unless I double click the cell and push ent | Excel Discussion (Misc queries) | |||
| Cannot get VALUE function to work with cell references | Excel Worksheet Functions | |||
| Now With Index -- IF Function Does Not Work With Cell Reference | Excel Worksheet Functions | |||
| IF Function Does Not Work With Cell Reference | Excel Worksheet Functions | |||
| how do i get the mid function to work with a zero | Excel Worksheet Functions | |||
Linear Mode
