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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ChartObject Name property allowed characters
Solution: Alternative function to method WorkSheet.ChartObjects(chartObjectName). The method WorkSheet.ChartObjects(chartObjectName) doesn't work doesn't return ChartObject which Name property contains character "-" (at least). Function below works correctly. ' returns ChartObject with name...- xjena
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ChartObject Name property allowed characters
That works fine! I need to do this (apart from other things): Dim co as ChartObject, chartObjectName as String Set co = ActiveSheet.ChartObjects(chartObjectName) ... with given chartObjectName. Apparently this code doesn't work for chartObjectName containing "-" character for the same...- xjena
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ChartObject Name property allowed characters
The value of ActiveSheet.ChartObjects.Count is 2. On the active sheet in Excel I can see Two chart objects. If I select each by clicking on it while holdinf Ctrl key, they have right names, see- xjena
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ChartObject Name property allowed characters
I didn't notice that I'm using Microsoft Excel 2002 SP3. Sorry.- xjena
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ChartObject Name property allowed characters
Hi, I'm trying to write some macro in VBA for Excel that manipulates with charts. I'm using ChartObject and I need to access them by name, so I rename them as shown in code sample below. Sub test() ' add two new chart objects and name them Dim co As ChartObject Set co =...- xjena
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
