admin管理员组文章数量:1326507
I have a workbook with a worksheet containing my formulas. in that worksheet I have a named range in a cell called "FORMULA_VERMELL" containing the text "="TMP!A1"" (I plan to contain a more complicated formula in the future, of course)
In another worksheet called TMP, I have a value '123' in the cell A1
in another cell from TMP I am calling my custom vb function TextToFormula:
Public Function TextToFormula(cellRef As String)
TextToFormula = Evaluate(cellRef)
End Function
... like this: =TextToFormula(FORMULA_VERMELL)
This converts a text containing a formula, into a real formula and evaluates it.
The problem is that if I change the value in A1 from '123' to another value, the cell containing the formula
=TextToFormula(FORMULA_VERMELL)
does not automatically change, as it is not directly referencing the A1 formula, but using the named range. So I have to edit the cell with F2+ENTER
for it to recalculate.
Thanks in advance !
本文标签: excelAuto recalculate special casehow toStack Overflow
版权声明:本文标题:excel - Auto recalculate special case, how to - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1736110516a1904734.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论