I am hoping one of you can help me out. For some reason, what I believe to be returning a date is returning the value 1.
Some more input:
- Cell E2 (which is J2.Offset(0, -5)) value is 3/31/2007 (real date, not text)
- Variable myDay, which should return a serial date, is returning the value 1 as noted in the Immediate Window.
Here is the relevant code:
Here is the code for the UDF "EndMonth":Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks