I am trying to make a calculation in a table using VBA. The formula below works in Excel, but when I try to use it in VBA I get a #VALUE! error. Any ideas what I'm doing wrong?
.ListColumns("AFF.TIME").DataBodyRange.Formula = Evaluate("IF([oldAFF.TIME]="",[TIME],[oldAFF.TIME])")
Bookmarks