Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to pass the range as a variable to a chart macro?
Hi RHeilman, Thanks for your advice. I used your idea in a slightly different way and got it working successfully. I wrote the start and end rows in cells B1 and B2 respectively and then read those values and constructed the addresses in the macro. I had to use "JWalk Chart Tools" to...- vjay
- Post #4
- Forum: Microsoft VBA - Visual Basic for Applications
-
How to pass the range as a variable to a chart macro?
In Excel, when creating a Macro to plot a chart, the follwoing code was recorded. Sub PlotGraph2() ' ' PlotGraph2 Macro ' Macro recorded 13/05/2002 by Vasantha Jayasinghe ' ' Keyboard Shortcut: Ctrl+g ' Sheets.Add Range("B9").Select Charts.Add ActiveChart.ChartType =...- vjay
- Thread
- Replies: 3
- Forum: Microsoft VBA - Visual Basic for Applications
