Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ActiveSheet.Name not working when used with ActiveChart.Location?
Thanks for the tip! Setting up the sheet name outside the "charting block"... Dim SheetName As String SheetName = ActiveSheet.Name ...followed by... ActiveChart.Location _ Where:=xlLocationAsObject, _ Name:=SheetName Did the trick nicely.- KiwiSteve
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ActiveSheet.Name not working when used with ActiveChart.Location?
I have a macro which constructs a chart - it works fine with hard-coded sheet names, but I need it to work on other sheets. When I substitute the sheet name with ActiveSheet.Name it no longer works... eg. This works: ActiveChart.Location Where:=xlLocationAsObject, _ Name:= "JAN05...- KiwiSteve
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
