A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi. In vba, we sometimes have to force an evaluation on these functions, because in vba, inputs are not really "dynamic"
We need to force an evaluation on some array formulas on the worksheet as well. For simplicity, we can force an evaluation with
the old Array trick of "--"
Out of habit, I like to use:
=EOMONTH(0+A1#,0)
because this works better in some advanced single-formula stuff.
With arrays, a "technique" is to check with different data (ie different months) to test.
This is because sometimes we "think" something is evaluated, but it isn't. ( I'll post an example later).
By changing the month, we see that it appears to work.
With the "new" way to do it, I hope these issues gets fixed in the future.
> ... ps. Please ignore the context . array in A1 ...... is easier to understand for demonstration purposes)
I would like to say "Thank you" :>)
So much nicer than the AK999:AK10100 = Z100 stuff (general idea) that gets posted. :>)