Re: Function VBA Help
Quote from cytop;777707
The reason you get #value is because the code is throwing an error. I did try to figure out the logic but failed, miserably.
First step: Add error handling to your function.
That, at least, will warn you when things are not right and perhaps you can begin to resolve it from there.
Ok I found my error before the macro runs turn off automatic formula update and after the macro runs I turn it back on using VBA of course. Thanks for everyone's help!