///<summary>
 ///Initializes a new instance of the <see cref="MB.WinEIDrive.Excel.NamedRangeCollection">NamedRangeCollection</see> class.
 ///</summary>
 ///<param name="worksheet">The worksheet to initialize NamedRangesCollection.</param>
 ///<param name="sourceNamedRanges">The source named range collection to initialize NamedRangesCollection.</param>
 internal NamedRangeCollection(ExcelWorksheet worksheet, NamedRangeCollection sourceNamedRanges)
 {
     this.namesList   = new ArrayList();
     this.namedRanges = new ArrayList();
     this.worksheet   = worksheet;
     for (int num1 = 0; num1 < sourceNamedRanges.NamedRanges.Count; num1++)
     {
         NamedRange range1 = sourceNamedRanges.NamedRanges[num1] as NamedRange;
         this.Add(range1.Name, range1.Range);
     }
 }
 ///<summary>
 ///Gets the <see cref="MB.WinEIDrive.Excel.NamedRange">NamedRange</see> with the specified name.
 ///</summary>
 ///<param name="name">Range name.</param>
 public NamedRange this[string name]
 {
     get
     {
         for (int num1 = 0; num1 < this.namedRanges.Count; num1++)
         {
             NamedRange range1 = this.namedRanges[num1] as NamedRange;
             if (range1.Name == name)
             {
                 return(range1);
             }
         }
         return(null);
     }
 }