Hi,

Try this,

ActiveChart.Parent.Left = Range("L2").Left
ActiveChart.Parent.Top = Range("L2").Top

Cheers
Andy

David wrote:

There is another way, where you designate the cell where
you want the upper left of the chart to be, but I can not
remeber the syntax. thanks David

-----Original Message-----
David,
<Object Browser
Property TopLeftCell As Range
read-only
Member of Excel.ChartObject
</Object Browser

Unless there's another way ??

NickHK


"David" wrote in

message

...

Hi Group,
Looked through several sources, but can not seem to

find

the code to make a chart the upper left corner

at "L2." I

know it exits, because I have done it before, but cn

not

remmber the syntax.
Thanks


.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info