Hi ScubaGirl A Function returns a value by assigning a value to its name in one or more statements of the procedure. The return type of a Function is always a Variant, unless you specified the type e.g. Public Function CalcResourceUtilization() as Boolean
If you had some statement within your function such as "CalcResourceUtilization = True" then the return value can be used... You did not specify any type (thus it returns a Variant) and you did not specify any Return Value (with statement CalcResourceUtilization = ...) then the return is EMPTY and in case you try to use this, it may generate that error: the type of the return value is not compatible with the operation or assignment you do at calling point... Good luck. Let me know if this helps you. Greetings Paul Willekens -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
