Hey there,
I'm trying to use vba to set a cell value. the cell value needs to be an formula which uses CUBEMEMBER. the last value is a string
the formula I need to set is =CUBEMEMBER("myCube"),"[Geo].[Region].&[01]","America")
where the "Americas" needs to be the string StrRegionName
here is the workbook and cell ref: wsData.Range("G8").Value = "<getting lost with the 2x quote syntax>".
your help is greatly appreciated.
I'm trying to use vba to set a cell value. the cell value needs to be an formula which uses CUBEMEMBER. the last value is a string
the formula I need to set is =CUBEMEMBER("myCube"),"[Geo].[Region].&[01]","America")
where the "Americas" needs to be the string StrRegionName
here is the workbook and cell ref: wsData.Range("G8").Value = "<getting lost with the 2x quote syntax>".
your help is greatly appreciated.