Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vba adding arrays
Hi
I am working with a lot of arrays, and I want to be sure that I am coding most efficiently. I have to add multiply and divide arrays, so for example I want to take Array1(100) +5*Array2(100), but it doesnt look like I can just say Array3(100)=Array1(100) +5*Array2(100) I have to code For i = 1 to 100 Array3(i)=Array1(i)+Array2(i)*5 Next i Is that how you deal with arrays, by using For loops? Thanks for your help |
#2
|
|||
|
|||
vba adding arrays
Yes, there is no array operators in VBA that I am aware of. You could dump
them to a worksheet range, create a formula to do it, then copy the result back in, but for 100 elements, hardly worth the bother. -- HTH RP (remove nothere from the email address if mailing direct) "Jeff" wrote in message ... Hi I am working with a lot of arrays, and I want to be sure that I am coding most efficiently. I have to add multiply and divide arrays, so for example I want to take Array1(100) +5*Array2(100), but it doesnt look like I can just say Array3(100)=Array1(100) +5*Array2(100) I have to code For i = 1 to 100 Array3(i)=Array1(i)+Array2(i)*5 Next i Is that how you deal with arrays, by using For loops? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D Arrays | Excel Worksheet Functions | |||
Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
problem adding | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Discussion (Misc queries) |