Hi friends, I wanna know if we can pass the variables without initializing them to any other function and get their values from that called function please find the below example. which is similar to that of i have seen.
dim workingday as some data type Sub calling () if not (calculateworkingday(workingday)) then .... ..... end sub public function calculateworkingday(abcd as some datatype) boolean some code here which give some value to abcd calculateworkingday = true end function -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel