| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a variable for dynamic chart
I have a excel file wich I have modified with a number of userforms, macros
and so on. One of the macros make a chart wich the user can page through several columns. One by one. I want the user to be able to save the file witout having to change the macro. I know how to define the open workbook as a variable, but I am not sure how to use a variable in this macro? ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "='Log_1.xls'!XValues" ActiveChart.SeriesCollection(1).Values = "='Log_1.xls'!YValues" ActiveChart.SeriesCollection(1).Name = "='Log_1.xls'!Name" Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
| Define Dynamic Name | Excel Discussion (Misc queries) | |||
| dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
| How to define variable | Excel Programming | |||
Threaded Mode
