Setting the scene:
I have a table of data linked to a chart.
I have a slider linked to a cell (A1)
As the slider is moved, all of the values change, in turn changing the chart.
Challenge:
Every time the slider changes cell 'A1', take an image of the chart and paste to the right of it. This is to enable the user to compare the two.
When the cell A1 is changed again the image needs to be refreshed with the previous state
Note: I would upload an example but I'm posting this topic from my phone and can't access my docs.
Thanks again for the help.