Spreadsheet.UnMarkAll

This function removes all marked cells.

Syntax Parameters Return Value
- This function has no parameters. This function does not return a value.

SVB Example

Marking and unmarking cells: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    Dim r As Range
    'assigns the range 1,1,2,2 to the range object r
    Set r = spr.CellsRange(1,1,2,2)
    'sets the range as marked cells
    r.AddToMarked
    'using the spreadsheet display attributes, displays the marked cells
    spr.DisplayAttribute(scDisplayMarkedCells) = True
    'displays a message box, when ok is pressed marked cells will be removed
    'the purpose of the message box is to pause execution so that
    'the marked cells can be seen.
    MsgBox("The marked cells will now be unmarked",vbOkOnly)
    'removes all the marked cells
    spr.UnMarkAll
End Sub