SPS
Moderator
My aim is to rotate a cube in Excel using graphs/charts and matrices using a macro.
My method involves using a for loop from 1 to 360 passing the loop counter into a cell to be used in the matrix calculations.
Using:
For i = 1 to 360
Cells(2,7) = i
Next i
Increments the correct cell as expected. However, during the execution of the For loop the graph/chart does not refresh.
So what I need to know is, is there a way of refrencing the already existing graph/chart inside the for loop to do a refresh on each iteration as there is a .refresh method?
I have tried multiple sources online and I am having no luck and wondering if it is even possible.
Any help would be greatly appreciated.
Cheers
My method involves using a for loop from 1 to 360 passing the loop counter into a cell to be used in the matrix calculations.
Using:
For i = 1 to 360
Cells(2,7) = i
Next i
Increments the correct cell as expected. However, during the execution of the For loop the graph/chart does not refresh.
So what I need to know is, is there a way of refrencing the already existing graph/chart inside the for loop to do a refresh on each iteration as there is a .refresh method?
I have tried multiple sources online and I am having no luck and wondering if it is even possible.
Any help would be greatly appreciated.
Cheers
