I am relatively new to excel vba and trying to teach myself as I go. I am working with 2016.
I have a spreadsheet that has a large bordered cell (frame, maybe?). On another program I generate pie charts which I copy and paste to my spreadsheet. The names of the pasted charts are always randomly generated.
I would like to be able to drag the pasted chart over the large bordered cell and upon releasing the mouse button, the chart will automatically snap into the cell, taking on its dimensions, and renaming the chart to something more standardized for easier indexing. Please assist. Thanks in advance.
I have a spreadsheet that has a large bordered cell (frame, maybe?). On another program I generate pie charts which I copy and paste to my spreadsheet. The names of the pasted charts are always randomly generated.
I would like to be able to drag the pasted chart over the large bordered cell and upon releasing the mouse button, the chart will automatically snap into the cell, taking on its dimensions, and renaming the chart to something more standardized for easier indexing. Please assist. Thanks in advance.