[已解决]function函数

xiaoni

function  aa（rg）
aa=rg.clearformats
end function这样写怎么不对呢？

最佳答案

月排行榜 / 总排行榜

adders

2012-3-23 22:02

I hope you don't mind me typing in English as I'm at work...

Don't confuse Function as oppose to Sub. A Function always returns a VALUE, while a Sub is a set of procedures/actions that works as it's designed.

In a nutshell, 函数返回的结果应该是一个值.

Also refer to my response to this thread:
http://www.excelpx.com/forum.php?mod=viewthread&tid=212965&page=1#pid2977148

跳转到最佳答案楼层

无聊的疯子

ms方式不对哦?

按你这思路来说,如果我们要清除 A1 里的值,写成自定义函数
Function aa(rg As Range)   参数 rg 输入A1
  aa = rg.ClearContents    '这样的?能行?'
End Function

如果是删除呢??
aa=rg.delete   这样的?

adders

I hope you don't mind me typing in English as I'm at work...

Don't confuse Function as oppose to Sub. A Function always returns a VALUE, while a Sub is a set of procedures/actions that works as it's designed.

In a nutshell, 函数返回的结果应该是一个值.

Also refer to my response to this thread:
http://www.excelpx.com/forum.php?mod=viewthread&tid=212965&page=1#pid2977148