Consulting

Results 1 to 2 of 2

Thread: Macro not running properly on other systems

  1. #1

    Macro not running properly on other systems

    Dea all,

    I am facing some very strange problem

    I have written a very simple macro to select all the chart objects on active sheet. On my pc it is running fine selecting all the available graphs on the active sheet. but when I run this macro on my office system it used to select only the last graph on the sheet, not all.

    what can be the reason for this strange behaviour?
    Please help in this regard.

    Code is as follows:
    Sub SelectAllchart()
    ActiveSheet.ChartObjects.Select
    End Sub

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Be sure to work off of the same file. Otherwise, I don't see why it would not work properly. Be sure to check that you have more than one chart on the activesheet.
    MsgBox ActiveSheet.ChartObjects.Count

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •