Reading data from array

[thakkarvamar]

Hi

I populated an array as follows

Dim arrRatios As Variant


Set range_source = ws13.Range(.Cells(r, c), .Cells(r, c + 37))

arrRatios = range_source.Value



How do I use the values in array now? I want to be able to access any 1 value at a time
something like arrRatios(3)

 

[Peter_SSs]

Reading a range into an array creates a 2 dimensional array. The first dimension is the 'row' and the second dimension is the 'column'. Since your range is from a single row, try

arrRatios(1,3) to access the value from the third column of the range.

 

[thakkarvamar]

Yes it is working .. thanks a lot