Method: RemoveAll for Areas

Method: RemoveAll for Areas

Deletes all elements from the Areas collection.

Object.RemoveAll()

The following example deletes all areas except the last one, in the enabled worksheet:

Dim MyName : MyName = View.ActiveSheet.ActiveArea.Name
Call View.ActiveSheets.Areas.Removeall

MyName = dd.View.ActiveSheet.ActiveArea.Name 
dd.View.ActiveSheets.Areas.Removeall()