'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