sun_g_leo
09-12-2013, 10:09 PM
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
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