AnsweredAssumed Answered

VBA Datalink Sampled Data

Question asked by parasyn on Jun 17, 2015
Latest reply on Jun 18, 2015 by parasyn

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

any ideas?

 

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,)"
ranker.Select
Call DlResize

 

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.

Outcomes