Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Charts > VBA Code > Moving< Previous | Next > 

 
1
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
   


 

Moving and Resizing charts

 
 
2
3
4
5
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet2"
ActiveSheet.Shapes("Chart 2").IncrementLeft -10.5
ActiveSheet.Shapes("Chart 2").IncrementTop -5#
Call MsgBox(ActiveChart.Parent)
   



 © Better Solutions Limited 10-May-2013< Previous | Top | Next >