Hi all,
I have a cell that I put a date into.
I then make that cell a named range "end_date".
The formula I am using is =year(end_date).
If I use VBA to calculate the cell it won't update.
The only way I can get it to update is click on the cell and press enter.
Any ideas?
Thanks
Bookmarks