VBA Code:
Data = Sheets("Data").Range("Values2020").Value
For i = 1 To UBound(Data)
area = Data(i, 1)
aval = Data(i, 2)
myFunc area, aval
Next i
First row is headers.
Column A contains names, column B to F contains values, named Values2020 to Values2025.
I am trying to offset Data somehow so that I can loop from column B to column F or column X...
I have tried with an outer loop:
VBA Code:
Dim j As Integer
For j = 1 to 5
Data = Sheets("Data").Range("Values202" & j).Value
Next j
Any suggestions?