Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Me again.
I am trying to create a macro to create a chart as a new sheet. The data I am charting is consistently in the same cells on multiple "data" sheets. I am trying to create 1 chart per sheet. I recorded a macro, and at this point: Selection.Text = "='A-1 Data'!R4C5:R4C10" ActiveChart.PlotArea.Select With Selection.Border .Weight = xlThin .LineStyle = xlNone I would like to be able to automatically refer to the sheet that was active when the macro was started. I would also like for the chart sheet to be automatically named as per the chart title. Can the macro also give me a user input with GUI where I can select the xls file in which I would like the chart to be created? Am I dreaming? Thanks CaliberX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) |