I'm sorry. Use

Dim myName As String

myName = Replace(ActiveChart.Name, ActiveSheet.Name & " ", "")

ActiveSheet.Shapes(myName).IncrementLeft -147.75
ActiveSheet.Shapes(myName).IncrementTop 66

HTH,
Bernie
MS Excel MVP


"wussupbuddy" wrote in message
...

but how do I get to know the name of the chart that has just been
created using the macro?


--
wussupbuddy
------------------------------------------------------------------------
wussupbuddy's Profile: http://www.excelforum.com/member.php...o&userid=32107
View this thread: http://www.excelforum.com/showthread...hreadid=518650