Passing a worksheet object

[brianh]

(VBA) If I have a class with a function that takes a worksheet as an argument. And I am creating a worksheet dynamically right before i call that class function, how do I place that dynamically created worksheet name into the argument when I call that function?

[BrianB]

I am not an expert here, but can't you have a class member such as WorksheetName and use that ? eg.

MyClass.WorksheetName = ActiveSheet.Name

[FantastichenEin]

There will be a collection of worksheets called Excel.Worksheets, just pass the worksheet that you created.