Hello.
First post, please be kind
I have a sheet with several graphs. They are all stacked vertically. I´m looking for a macro that will send them all one column over to the right.
To select all charts I found:
And based on a recorded macro, they can be moved to the right with:
48 seems to be the increment level for 1 column.
I´m hoping there is a way to combine the two, and do what I need with the press of a button.
Thanks in advance!
First post, please be kind
I have a sheet with several graphs. They are all stacked vertically. I´m looking for a macro that will send them all one column over to the right.
To select all charts I found:
VBA Code:
ActiveSheet.ChartObjects.Select
Code:
IncrementLeft = 48
I´m hoping there is a way to combine the two, and do what I need with the press of a button.
Thanks in advance!