I think i need some idea on this....where mac() is a dynamic array, so instead i use UBound to get its number of elements. However, i need the number of charts equal to the size of the array, so i think to use the code shown below:
B = UBound(mac) + 1 For G = 0 To B chart(0) = Chart1 chart(1) = Chart2 chart(2) = Chart3 chart(3) = Chart4 chart(4) = Chart5 chart(5) = Chart6 chart(6) = Chart7 chart(7) = Chart8 chart(8) = Chart9 chart(9) = Chart10
However, array chart() can be looped, but Chart1,Chart2......cant.
How can i make it? Thanks for the help...