Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In our last episode Simon wrote:
=ybegin line=128 size=50176 name=example.xls Attachment decoded: example.xls =yend size=50176 crc32=1752eedb further to this I discovered that it was only the first of the nested functions (Cost) that was hiccuping... All the others appear to work OK, but this one needed to be 'added' again before it would work as expected. I tried (unsuccessfully) adding a dummy function before this one, adding the same function twice, and renaming the function. In frustration, I added all the nested functions (Cost - Cost4), then deleted Cost and added it again - SUCCESS!! So I changed the sequence and added Cost last (instead of adding, then deleting, then adding again) and it works as advertised... Not sure why this might occur, but if anyone has any ideas I appreciate hearing them... many thanks S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Array to named range conversion... | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |