Hi I'm using this code to pull in queries and I'm wondering how to loop through reference rows. So the 1st query is in C69, the last is in C80. Each new query would start in row after the last entry of the previous one.
VBA Code:
Dim rngAnchor As Range
Dim strQuery As String
strQuery = ws6.Range("C69")
With ws2
Set rngAnchor = .Range("A2")
With .QueryTables.Add(Connection:=strQuery, Destination:=rngAnchor)
.Refresh BackgroundQuery:=False
End With
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
.Rows("3:" & LastRow).RowHeight = 12
End With