This documentation is archived and is not being maintained.

AllowEditRanges.Add Method 

Adds a range that can be edited on a protected worksheet.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim Title As String
Dim Range As Range
Dim Password As Object
Dim returnValue As AllowEditRange
Dim allowEditRanges1 As AllowEditRanges
returnValue = allowEditRanges1.Add(Title, Range, Password)

AllowEditRange Add(
	[In] string Title, 
	[In] Range Range, 
	[In, Optional] object Password
public AllowEditRange Add(
	/*in*/System.String Title, 
	/*in*/Range Range, 
	/*in*/System.Object Password
function Add(
	 Title : String, 
	 Range : Range, 
	 Password : Object
) : AllowEditRange;



Optional Object. The password for the range.


Required String. The title of range.


Required Range object. The range allowed to be edited.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms