Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-26-2014, 05:38 PM
whatsup whatsup is offline #REF! Error in calling VBA function disappears when function is copied Windows 7 64bit #REF! Error in calling VBA function disappears when function is copied Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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.
Reply With Quote
 



Similar Threads
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
#REF! Error in calling VBA function disappears when function is copied Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
#REF! Error in calling VBA function disappears when function is copied Sub or Function not defined error - GetParaIndex Word 2010 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft