 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008#VALUE! from Function()...Posted in Excel General Questions by mis
I meant to post this question here, but accidentally ended up posting it in the Excel General Questions forum. Rather than re-post the entire message here, I'll summarize the question here. If you are interested, please go to Excel General Questions and view the entire post there. I've written a function() that validates the interrelationship between 3 cells. When I run the function with all 3 cells empty, I get the #VALUE! error. Can anyone spot what's triggering the #VALUE! error, or suggest further debugging ideas? What's your formula (function)? >I meant to post this question here, but accidentally ended up posting it in > the Excel General Questions forum. Rather than re-post the entire message [quoted text clipped - 6 lines] > #VALUE! error. Can anyone spot what's triggering > the #VALUE! error, or suggest further debugging ideas? Thanks for your reply. The code is shown in detail in the other forum. As I said "If you are interested, please go to Excel General Questions and view the entire post there." Perhaps I should not worry about duplicating the entire post here? Some forums get really upset over that. > What's your formula (function)? > [quoted text clipped - 8 lines] > > #VALUE! error. Can anyone spot what's triggering > > the #VALUE! error, or suggest further debugging ideas? I didn't get a solution from either forum where I posted this message. I found the error to be in using a RETURN statement instead of an EXIT statement where I wanted an immediate return from the function, rather than letting the funtion exit dy default at the END FUNCTION statement. Kindof suprised that the compiler did not flag the RETURN statement, which apparently is not a legal VBA statement. > Thanks for your reply. > [quoted text clipped - 17 lines] > > > #VALUE! error. Can anyone spot what's triggering > > > the #VALUE! error, or suggest further debugging ideas? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.