Re: $$Excel-Macros$$ User Defined Function not updating

2010-08-20 Thread Paul Schreiner
if you want, send me the file and I can look closer. Paul From: Jacob To: MS EXCEL AND VBA MACROS Sent: Fri, August 20, 2010 10:16:57 AM Subject: $$Excel-Macros$$ User Defined Function not updating I have a user defined function that is not updating.  The way

$$Excel-Macros$$ User Defined Function not updating

2010-08-20 Thread Jacob
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 i