![]() |
|
#1
|
|||
|
|||
![]()
Hi
You can't use a cells address as name for functions, you intend to use in the worksheet itself. Though it works in your Sub Test(), you should generally avoid using names already excel has in use. This may cause problems, or as you see in your case errors. In Versions 2007 and above ODE45 refers to the cell of column 10249, row 45 and is therefore in use of Excel itself. Your function as it is will work perfectly in Versions up to 2003. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
![]() |
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
![]() |
jec1 | Word VBA | 1 | 05-24-2012 11:58 PM |
Error: "The function you are attempting to run contains macros" | Fadi | Word | 1 | 11-01-2011 05:25 AM |
Compile error: sub or function not defined.. | xena2305 | Excel Programming | 0 | 08-02-2011 10:17 AM |