northwolves[狼行天下] 的专栏

无知无惧,无欲无敌。

UDF to show the expression of cell formula.

With VBA, it's easy to show precedents of the cell :



But when we compile this as an UDF,it won't work in worksheet:

If we input a formula "=MyPrecedents(A1)" in [B1],it will show "$A$1" instead of "$B$2,$C$3,$D$9". It returns only the address of MyCell! I t is not passed to the function as an argument ,What's wrong with it?


Furthermore, if we need the expression with orign data, a feasible method is to use "Worksheet_Change" event subroutine instead. (See F36 of http://club.excelhome.net/viewthread.php?tid=663427&pid=4519978&page=4)



And after many tests,I found a way to use UDF at last.



阅读更多
想对作者说点什么? 我来说一句

ios Blaze VideoCell

2018年01月06日 669KB 下载

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭