AnsweredAssumed Answered

PISampDat function with VBA

Question asked by antmej on Jun 24, 2015
Latest reply on Jul 24, 2018 by HuiZhang



I'm new to datalink & vba so I'm having a little trouble. I'm currently pulling a lot of data with the PISAMPDat() function in my VBA program; I'm doing a lot of calculations with the pulled data. A range was created, with the calculation results being outputted using FormulaArray property. Is there any way to pull the data and instead of outputting it out to a FormulaArray in the spreadsheet, to keep it in some data structure within the VBA program? I'd rather keep everything in the data structure and only output the results of the calculations. The goal is to avoid printing any intermediate data and just have the user see the results quickly. Thank you for the help!