'How to use EVALCELL() with YEAR() in visio vba
I'm running into this problem with shape formulas. If I do this:
YEAR(NOW())
I get the result: 2022.0000 which is what I expect.
However, let's say I have two shape data rows: Prop.Foo and Prop.Bar.
Prop.Foo = YEAR(ARG("A"))
Prop.Bar = EVALCELL("Prop.Foo","A",NOW())
I get a #VALUE!
error in the result of Prop.Bar, and I don't understand why. Shouldn't I get 2022.0000?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|