your are setting the calculated value to an locally declared array, if you need to have those values outside this Sub, you have to declare the array in the general section. Also you have declared a fixed length array, are the 30 entries enough?