Vijay Anand
Board Regular
- Joined
- Jan 21, 2008
- Messages
- 69
Hi, I have Graphs which are autopopulated via VBA.
I managed to snap the generated graphs by following code which was given by Andrew....( Thanks Once again to him ).....
Sub Test()
Charts.Add
With ActiveChart
.Location Where:=xlLocationAsObject, Name:="Sheet1"
End With
With ActiveChart.Parent
.Top = Range("B10").Top
.Left = Range("B10").Left
End With
But Now I need to size the graphs...
They appear different on differernt monitors...
That is the lower corner of the graphs should also be snapped to a particular cell...
Pl help me with the VBA codes....
Thanks & Regards,
Vijay anand.R
I managed to snap the generated graphs by following code which was given by Andrew....( Thanks Once again to him ).....
Sub Test()
Charts.Add
With ActiveChart
.Location Where:=xlLocationAsObject, Name:="Sheet1"
End With
With ActiveChart.Parent
.Top = Range("B10").Top
.Left = Range("B10").Left
End With
But Now I need to size the graphs...
They appear different on differernt monitors...
That is the lower corner of the graphs should also be snapped to a particular cell...
Pl help me with the VBA codes....
Thanks & Regards,
Vijay anand.R