传递给一个函数（excel vba） [英] pass sheet to a function (excel vba)

问题描述

我一直在尝试将工作簿中的工作表传递给一个功能，但似乎没有工作。该功能是

I've been trying to pass a sheet in my workbook to a function, but it doesn't seem to be working. The function is

Private Sub passToSheet(theData As Variant, Optional mySheet As Worksheet)

我尝试过

Dim mySheet as Worksheet
Set mySheet = "Results"

然后调用函数

passToSheet theData mySheet

但似乎不起作用我不是很确定谷歌如何获得正确的方式来参考工作表虽然！任何帮助非常感谢！

but it doesn't seem to work. I'm not really sure what to google to get the right way to reference the worksheet though! Any help is much appreciated!

推荐答案

使用

'Set mySheet to worksheet
Set mySheet = Worksheets("Results")

获取工作表的引用。

这篇关于传递给一个函数（excel vba）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！