| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use vba to write vba for a chart sheet created on the fly
How do I write vba using vba for a chart sheet I have just created on
the fly? I 've noticed excel gives the vbcomponent a different name to the chart name which makes it difficult to select the correct vbproject Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use vba to write vba for a chart sheet created on the fly
Depends on how you create the chart sheet, but if with the Charts.Add method
then Dim NewChart as Chart Set NewChart = Workbooks("WorkbookName").Charts.Add() Now use the variable NewChart to refer to the chart object, or use its .Name property if you need that. -- - K Dales " wrote: How do I write vba using vba for a chart sheet I have just created on the fly? I 've noticed excel gives the vbcomponent a different name to the chart name which makes it difficult to select the correct vbproject Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| created chart will not display | Charts and Charting in Excel | |||
| Chart created on larger screen - Help | Charts and Charting in Excel | |||
| write formula that icludes data from sheet 1 to sheet 2 of my spr | Excel Worksheet Functions | |||
| How is a Paretto chart created in Excel? | Charts and Charting in Excel | |||
| Can hyperlinks be created in an organization Chart | Charts and Charting in Excel | |||
Hybrid Mode
