Hi Please add this line to your function. Adding on the first line will be good.
Application.Volatile This will cause recalculation of the function when any value change in the sheet. (So directly affect the speed if you use function on many cell) Thanks & Regards Sandeep On Fri, Aug 20, 2010 at 9:29 PM, Jacob <app...@gmail.com> wrote: > Thanks for getting back to me. I have attached a demo workbook. Row > 14 contains one of the formulas in questions. > > > http://excel-macros.googlegroups.com/web/TestWkb.xlsm?gda=xZn4GD4AAAAo61zD5UnH__xR-dBifwHhv_d2uiRDKQGL8zFE3ZFTfWRBti8nExtn9c0KYrNRRjDjsKXVs-X7bdXZc5buSfmx&gsc=brmZ0QsAAACht2TsvJ2a1-7tewzVg2bO > > Let me know if the link work for you. > > Thanks, > > Jacob > > On Aug 20, 10:16 am, Jacob <app...@gmail.com> wrote: >> I have a user defined function that is not updating. The way it works >> is based on HireDate. It looks at the hiredate and compares it to the >> budget year. IF the budget year is in the same year as the hire date >> then it looks at the row which could C:N or Jan-Dec. It works fine >> until I actually input a hire date in the current year. It then zeros >> everything out. If I go through the cell and hit "F2" that is = or >> after the hire date month then it recalculates. I would like for it >> to auto recalculate without having to hit "F2" on the cell. >> >> Any Help would be greatly appreciated. >> >> Thanks, >> >> Jacob >> >> Function rre_Salary(HireDate As Variant, Rate As Long, Weeks As >> Integer, Allocation As Integer) >> Dim BudgetYear As Integer >> BudgetYear = Sheets("Primary Info").Range("C11").Value >> If Year(HireDate) = BudgetYear Then >> If ActiveCell.Column - 2 >= Month(HireDate) Then >> rre_Salary = Rate * Allocation * Weeks >> Else >> rre_Salary = 0 >> End If >> Else >> rre_Salary = Rate * Allocation * Weeks >> End If >> 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 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 > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
