'Declaration
 
Public Overloads Function Add( _
   ByVal sourceWorksheetName As String, _
   Optional ByVal visibility As WorksheetVisibility _
) As Worksheet

'Usage
 
Dim instance As WorksheetCollection
Dim sourceWorksheetName As String
Dim visibility As WorksheetVisibility
Dim value As Worksheet
 
value = instance.Add(sourceWorksheetName, visibility)

public Worksheet Add( 
   string sourceWorksheetName,
   WorksheetVisibility visibility
)

Parameters

sourceWorksheetName

Identifies the Worksheet that will be added to the WorksheetCollection by using a string that corresponds to its name.

visibility

Sets how the added Worksheet is displayed. The default setting is Visible. 

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

WorksheetCollection Class
WorksheetCollection Members
Overload List