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!

Register Log in
  • 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!

Recent content by xjena

  1. xjena

    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...
  2. xjena

    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...
  3. xjena

    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
  4. xjena

    ChartObject Name property allowed characters

    I didn't notice that I'm using Microsoft Excel 2002 SP3. Sorry.
  5. xjena

    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 =...
See more

Part and Inventory Search

Back
Top