Data provider types: Oracle Essbase
Description
HypModifyRangeGridName() is used to modify the name of any given grid on a multiple-grid worksheet present in the active workbook.
Syntax
Private Declare PtrSafe Function HypModifyRangeGridName Lib "HsAddin" (vtSheetName, vtGridName, vtNewGridName) As Long
ByVal vtSheetName As Variant
ByVal vtGridName As Variant
ByVal vtNewGridName As Variant
Parameters
vtSheetName: The name of the worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtGridName: Name range of a grid on a multiple-grid worksheet. This parameter cannot be Null or Empty.
vtNewGridName: New name range of a grid on a multiple-grid worksheet. This parameter cannot be Null or Empty.
Example
Sub modifyName()
s = HypModifyRangeGridName("Sheet1", "Demo15FCFBC11_9D65_4555_94AC_6EDD429438B0_1", "someNewGridName")
End Sub