How to set paramarray value in HypSetPages SmartView VBA function

Hi Experts,

I have tried to found example or explanation to this but not found.

With HypSetPages function one can programmatically change Page value(s) in the data form that has been downloaded to Excel sheet.

It works correctly for example like this:  x = HypSetPages(Empty, "Period#Jan")    WHEN I have inputted the value in the code directly.

When I try to input the dimension:value item as a variable, it gives me error -3: Initialization Error

Function declaration:  Public Declare PtrSafe Function HypSetPages Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray MemberList() As Variant) As Long

So I suppose I should give the value pre-formatted as array. I have not yet found a way to define properly the format needed (have tried...)