Set position of excel chart to cell A1
Try code like
With ActiveSheet.ChartObjects(1)
.Top = Range("A1").Top
.Left = Range("A1").Left
End With
"Jasonm" wrote in message
...
I have created code to insert a chart into an excel worksheet,
but the placement is not exactly where I would like to see it. I
would like to be able to give the chart an absolute position
such as Cell A1.
Does anyone know how I can do this?
Thanks in advance for your assistance.
jasonm
|