I am trying to retrieve samples for about 30 points.
I have the points in an excel sheet in range C1 to AJ1
If I use sampledata in excel I get the data I want a set of times down column B and data for all points in the range C1 to AJ1.
But if I try to do the same in VBA I am only getting data for one column, column C
Here is my vba code.
|Dim ranker As Range|
|Set ranker = Range("B3:C3")|
|ranker.FormulaArray = "=PISampDat($C$1,'Daily RO'!$J$4,'Daily RO'!$K$4,'picklist'!$L$3,1,)"|
I have tried changing the range but to no avail.
if I comment out dlResize I see a nice message resize to show all and all columns from D to AJ have #N/A
Thanks in advance.