Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking to create a new array with elements of a previously
created array. Whe For Each cell In Ratings ReDim Preserve Ratings1(6, rw) Ratings1(0, rw) = Ratings(0, rw) Ratings1(1, rw) = Ratings(1, rw) Ratings1(2, rw) = Ratings(2, rw) Ratings1(3, rw) = Ratings(3, rw) Ratings1(4, rw) = Ratings(4, rw) Ratings1(5, rw) = Ratings(5, rw) rw = rw - 1 Next Cell "Ratings" is my old array and "Ratings1" is my new array that i am creating. "Ratings" is in the same sub and will have the same number of row elements. For some reason this is not working. When im done not all elements of Ratings1 will be the same as the Ratings, but im just trying figure this part out. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use formulas for array elements | Excel Discussion (Misc queries) | |||
array elements count | Excel Programming | |||
Reference Elements w/in an Array | Excel Discussion (Misc queries) | |||
Non-unique elements in an array | Excel Discussion (Misc queries) | |||
Number of elements in an array | Excel Programming |