| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete chart
I am trying to find a way to delete a chart with VBA.I am able to create a
chart but not delete one.Thanks for your help Wayne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete chart
try
ActiveSheet.ChartObjects("Chart 1").Delete -- Don Guillett SalesAid Software "Wayne" wrote in message ... I am trying to find a way to delete a chart with VBA.I am able to create a chart but not delete one.Thanks for your help Wayne |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete chart
I get a message that says unable to get the ChartObjects property of the
worksheet class. "Don Guillett" wrote: try ActiveSheet.ChartObjects("Chart 1").Delete -- Don Guillett SalesAid Software "Wayne" wrote in message ... I am trying to find a way to delete a chart with VBA.I am able to create a chart but not delete one.Thanks for your help Wayne |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete chart
Thanks it works but an error message pops up it says Object vairiable or with
block variable not set.Do you know how I can get rid of this. Thanks for your help Wayne "Don Guillett" wrote: Perhaps your chart was NOT chart 1? Try this ActiveSheet.ChartObjects(1).Delete for all, try for each ch in activesheet.chartobjects ch.delete next ch -- Don Guillett SalesAid Software "Wayne" wrote in message ... I get a message that says unable to get the ChartObjects property of the worksheet class. "Don Guillett" wrote: try ActiveSheet.ChartObjects("Chart 1").Delete -- Don Guillett SalesAid Software "Wayne" wrote in message ... I am trying to find a way to delete a chart with VBA.I am able to create a chart but not delete one.Thanks for your help Wayne |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete chart
Thanks for that piece of code I got it to work thanks.I deleted my code and
used the 1 line you gave me. Thanks Wayne "Don Guillett" wrote: Perhaps your chart was NOT chart 1? Try this ActiveSheet.ChartObjects(1).Delete for all, try for each ch in activesheet.chartobjects ch.delete next ch -- Don Guillett SalesAid Software "Wayne" wrote in message ... I get a message that says unable to get the ChartObjects property of the worksheet class. "Don Guillett" wrote: try ActiveSheet.ChartObjects("Chart 1").Delete -- Don Guillett SalesAid Software "Wayne" wrote in message ... I am trying to find a way to delete a chart with VBA.I am able to create a chart but not delete one.Thanks for your help Wayne |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete chart
Glad to help -- Don Guillett SalesAid Software "Wayne" wrote in message ... Thanks for that piece of code I got it to work thanks.I deleted my code and used the 1 line you gave me. Thanks Wayne "Don Guillett" wrote: Perhaps your chart was NOT chart 1? Try this ActiveSheet.ChartObjects(1).Delete for all, try for each ch in activesheet.chartobjects ch.delete next ch -- Don Guillett SalesAid Software "Wayne" wrote in message ... I get a message that says unable to get the ChartObjects property of the worksheet class. "Don Guillett" wrote: try ActiveSheet.ChartObjects("Chart 1").Delete -- Don Guillett SalesAid Software "Wayne" wrote in message ... I am trying to find a way to delete a chart with VBA.I am able to create a chart but not delete one.Thanks for your help Wayne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a # from the value axis on a column chart? | Excel Worksheet Functions | |||
| line appears when deleting chart- cannot delete it | Excel Worksheet Functions | |||
| How do I delete chart superimposed on Excel document? | New Users to Excel | |||
| Chart, Series delete event | Charts and Charting in Excel | |||
| Delete Chart | Charts and Charting in Excel | |||
Linear Mode
