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.

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.

Community Additions

ADD
Show: