Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Charts
I replied to my own post, but somehow it doesn't show up, so I'm doing a
second post. Shortly after my original post I discovered my (many) errors and confusions. My immediate problem is solved. For the record, the problem with my original code, which was symmetrical between the two cases of the If, arose because I used ActiveSheet.Name as the destination in the case of an embedded chart (xlLocationAsNewSheet, Name:= ActiveSheet.Name). That gave a critical error that crashed the entire app. Trying to resolve it set me on a completely wrong path. Assigning sheetname earlier in the sub works fine. tk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Charts
George -
I posted a more detailed solution than this, please have another look in the newsgroup. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ George Raft wrote: I replied to my own post, but somehow it doesn't show up, so I'm doing a second post. Shortly after my original post I discovered my (many) errors and confusions. My immediate problem is solved. For the record, the problem with my original code, which was symmetrical between the two cases of the If, arose because I used ActiveSheet.Name as the destination in the case of an embedded chart (xlLocationAsNewSheet, Name:= ActiveSheet.Name). That gave a critical error that crashed the entire app. Trying to resolve it set me on a completely wrong path. Assigning sheetname earlier in the sub works fine. tk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts from 2003 not working in 2007 | Excel Discussion (Misc queries) | |||
Charts.add stopped working | Charts and Charting in Excel | |||
Pivot Charts on Web not working | Charts and Charting in Excel | |||
Working with two charts | New Users to Excel | |||
Working with Charts | Excel Discussion (Misc queries) |