/// <summary> /// Formats the name. /// </summary> /// <param name="definedNames">The defined names.</param> /// <param name="name">The name.</param> /// <returns></returns> private static string FormatName(DefinedNames definedNames, string name) { if (string.IsNullOrEmpty(name)) { name = "Range"; } name = FormatName(name); // Check for duplicate names. string numberedName = name; for (int i = 1; definedNames.OfType <DefinedName>().Any(d => string.Equals(d.Name, numberedName)); i++) { numberedName = string.Format("{0}_{1}", name, i); } return(numberedName); }