SetRange
function SetRange(sRange: string = null): booleanDescription
Sets a range to the current protected range.
Parameters
- sRange
stringdefault: null The cell range which will be set for the current protected range.
Returns
booleanTry It
var oWorksheet = Api.GetActiveSheet();
oWorksheet.AddProtectedRange("protectedRange", "Sheet1!$A$1:$B$1");
var protectedRange = oWorksheet.GetProtectedRange("protectedRange");
protectedRange.SetRange("Sheet1!$A$2:$B$2");