ActiveChart.Location help
Hi Guys,
In a macro I have the following line: ActiveChart.Location Whe=xlLocationAsNewSheet How can I use a different line to put the chart in a sheet e.g. Sheet_Chart that is already present, in a particluar place? I have posted this question here - http://www.excelforum.com/showthread.php?t=623207 also, but have not yet got an answer. Thanks Dave |
ActiveChart.Location help
From the object browser in the VB Editor:
Function Location(Where As XlChartLocation, [Name]) As Chart so try this: ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave" wrote in message ... Hi Guys, In a macro I have the following line: ActiveChart.Location Whe=xlLocationAsNewSheet How can I use a different line to put the chart in a sheet e.g. Sheet_Chart that is already present, in a particluar place? I have posted this question here - http://www.excelforum.com/showthread.php?t=623207 also, but have not yet got an answer. Thanks Dave |
All times are GMT +1. The time now is 10:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com