Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon
 
Posts: n/a
Default Help with 'named' functions **SUCCESS**

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamically building references to named ranges [email protected] Excel Discussion (Misc queries) 1 January 3rd 06 10:23 PM
Array to named range conversion... i-Zapp Excel Discussion (Misc queries) 4 October 25th 05 09:09 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
Visible rows and functions that work tracy Excel Worksheet Functions 2 August 19th 05 05:25 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"