Allows changing a Viewport dynamically.

PropertyDescriptionValue
RangeSets the range that'll be displayed in the Viewport.

Text. This must be the text of the range, not a reference to it.


Correct:

=XL3SetProperty(viewport, myVP, range, Sheet1!A1:D10)

Incorrect:

=XL3SetProperty(viewport, myVP, range, Sheet1!A1:D10)

Note the quote marks around the address.

VisibleToggle whether the Viewport is visible.TRUE or FALSE