public static IEnumerator GetRangeCells(Range range) { Type t = range.GetType(); PropertyInfo pCells = t.BaseType.GetProperty("Cells"); Array cells = (Array)pCells.GetValue(range, new object[0]); return(cells.GetEnumerator()); }