Hi guys,
Total noob to VBA here so please be kind.
We use a Plant Information system here at work to keep track of various machine values - pressure, temperature etc.
I have been using the PI-Data Link Excel add-in to build a graphical representation of running hours on certain machine components.
It all works as expected but I would like to make it user friendly for others.
I have a graphic on one worksheet displaying the calculated values, on the second worksheet is the data including an array taken from PI and updated based on when the components were last changed up until =NOW().
Question: Is there a way to add a button to the first worksheet that will resize the array in the second worksheet to fit the available data? Rather than having to right click in the array and clicking 'Recalculate (Resize) Function'?

Any advice would be greatly appreciated.