Class related Stuff New Instancing

[DocAElstein]

https://www.excelforum.com/excel-pro...ml#post4383957
https://www.excelforum.com/excel-pro...ml#post4383975
https://www.excelfox.com/forum/showt...ll=1#post24202

---

To be hones, not sure I understand your question
the code should be

Sub example()
    Dim ws As Worksheet
    Set ws = Worksheets.Add 'ActiveWorkbook is assumed by default, also the new ws is added at the end, but you can specify after or before specific sheet
    MsgBox ws.Name 'Just an example for use of the ws variable/object
End Sub

Hi buran,
Thanks for the reply.
That is not really what I am talking about.

I understand what you have explained.
You are using the Worksheets Method .Add to make a new sheet..
I have no problem with either making a new, or copying an existing, Worksheet.

I am talking more generally about VBA Classes, Objects, and the different way one instances those. ( I am not trying to create or add a Worksheet with
Set ws = New Worksheet
- This is a code line recognised by VBA ( via intellisense ) which from Syntax appears correct to set a new instance from the VBA Class Worksheets. The line is not necerssary. But I am ( was ) puzzled that in errors. My point was that it I expected that VBA allowed it not to be written, but that it was an implied code line, an Implied Default. As such I should be alowed to enter it. Or so i thought ; ) )

So what I am talikng about is something quite different

I am talikng about advanced ( slightly ) VBA Theory.

I am looking for "Help Understanding Class Instancing"

But thanks anyway for the Reply. Appreciate the effort.

Alan