Why is .Value not necessary in my code?

[Dimitris254]

vararray_test(i, 1) = vararray_test(i, 1) * Worksheets("exchange_rate").Cells(1, "B").Value

i got one variant array in a local currency, then convert it to EUR (i do this for more values, hence the loop). The variant is filled with a range from a sheet "data". The cell (1, "B") holds the exchange rate for that currency.

The result is correct with and without the Value. Why?

Also, is it possible to convert the whole array to USD, by simply:

' today's EUR to USD exchange rate = 1.15
vararray_test= vararray_test * 1.15

 

[theBardd]

It is not necessary because Value is the default property for the Range object. Personally, I always use it regardless, I don't trust MS to always keep it that way, at least I didn't when VBA was still a viable product in their marketing eyes.

 

[Caleeco]

I believe .value is the default range property if it is not specificed - someone may come to correct me shortly! See link below for more information:

https://fastexcel.wordpress.com/2011/11/30/text-vs-value-vs-value2-slow-text-and-how-to-avoid-it/

Hope that helps
Caleeco

 

[GTO]

...and no, AFAIK, there is no way to work on all the elements of the array at once.

 

[Dimitris254]

It is not necessary because Value is the default property for the Range object. Personally, I always use it regardless, I don't trust MS to always keep it that way, at least I didn't when VBA was still a viable product in their marketing eyes.

was there a time that .Value was not the default property?

i'm new to VBA but i'm always interested in good programming techniques, one of which is to define something that was changed or might change in the future


@GTO: so, another loop is the only way?