ContainsCellText

Determines if the specified cell contains cell text. This function can be used in these types of rules:

Syntax

HS.ContainsCellText("POVExpression")

where POVExpression is a combination of members. If you do not specify a dimension, these default values are used.

Return Value

A Boolean expression that is True if the specified data cell contains cell text; False otherwise.

Example

In this example, if the specified cell does not contain cell text, then statements between the If...Then and End If lines are executed.

If HS.ContainsCellText("A#Sales.C1#Prod1.C2#Region1") = "False" then
  ...
End If