So I have VBA I wrote in Excel 2013 that works just fine, but which Excel 2007 apparently doesn't like.
Here is the code:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Cells(radd, [schedend].Column + 8) = "=IF(ISBLANK([@VOLUME]),D" & radd + 1 & ",[@VOLUME])"
This is an excerpt from a table entry macro, and the table formula will not go into the cell. I tried to troubleshoot it, and was able to use non-table formulas without problems. For example Excel 2007 likes this one just fine:
Cells(radd, [schedend].Column + 8) = "=IF(A1=""workdamnyou"",D" & radd + 1 & ",12345)"
So thoughts on how I make the table formulas work in Excel 2007???
Edit: Also, how does any of this affect users still on Excel 2003?
Bookmarks