有人知道这个VBA功能有什么问题吗？-Doesanybodyknowwhat'swrongwiththisVBAfunction?

Very simple, just

非常简单,只是

Function GetMonthRange(sheetMonth) As Range
GetMOnthRange= ActiveCell.Range("A1:AB1")
End Function

But Excel keeps lighting it up on me when I try to run my spreadsheet with an "Object variable missing" error. Number 91.

但是当我尝试运行带有“Object variable missing”错误的电子表格时,Excel会一直点亮它。 91号

I've isolated the code and it still lights up. I wouldn't ask, but I've spent an hour on it already, and restarting Excel everytime the debugger starts (because apparently Microsoft never figured out that sometimes we'd like to resume operation after a bug) is driving me up the wall.

我已经隔离了代码,它仍然亮着。我不会问,但我已经花了一个小时就已经开始了,并且每次调试器启动时都重新启动Excel(因为显然微软从来没有想过有时我们想在错误之后恢复运行)让我不得不把它推到墙上。

Also I'm pretty sure that Excel is maintaining its own clipboard.

另外我很确定Excel正在维护自己的剪贴板。

I'm going outside to kick a small dog.

我要到外面踢一只小狗。

P.S. Here's the link to the whole file if any real VBA programmers want a chuckle. Full admission here; I suck at Excel.

附:如果任何真正的VBA程序员想要轻笑,这里是整个文件的链接。完全入场;我吮吸Excel。

https://github.com/okamura1967/Directors_project_sheet/blob/master/project-sheet-for-directors.vbs

2 个解决方案

Function GetMonthRange() As Range
   Set GetMOnthRange= ActiveSheet.Range("A1:AB1")
End Function