Troubleshooting Exceptions: Microsoft.Office.Tools.InvalidRangeException

An InvalidRangeException exception is thrown when you programmatically create a view control with a range that spans multiple areas.

Associated Tips

  • Ensure that the area covered by the range does not overlap another range.
    Ranges cannot overlap.

  • Ensure when you programmatically create a view control that you include only a single area

    • Ensure when you programmatically create a view control that you include only a single area; that is, all the cells are together.

See Also

Tasks

How to: Use the Exception Assistant

Reference

InvalidRangeException