Edit

Share via

PivotValueCell.Creator property (Excel)

  • Article

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Syntax

expression.Creator

expression A variable that represents a PivotValueCell object.

Remarks

Because the object was created in Microsoft Excel, this property returns the hexadecimal value, 5843454C, which represents the string XCEL.

Property value

XLCREATOR

Example

The following code uses the Creator property to check whether the specified object is an Excel object.

Sub FindCreator() 
 Dim myObject As Excel.Workbook 
 Set myObject = ActiveWorkbook 
 If myObject.Creator = &h5843454c Then 
 MsgBox "This is a Microsoft Excel object." 
 Else 
 MsgBox "This is not a Microsoft Excel object." 
 End If 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.