is object chart?

J

Jan Karel Pieterse

Hi,

msgbox Typename(Selection)

Or

msgbox Typename(Selection.Parent)

Should give you some pointers.

Candidates:

ChartArea
ChartObject
Chart

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
J

Jon Peltier

Mark -

Try this:

If Not ActiveChart is Nothing Then
'' Selected object is a chart.
End If

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Move Chart with Text 0
Comparison of Microsoft Outlook 0
Ways to create a budget chart for money managment 1
Cannot see and gantt charts or other displays 0
How to create a bubble chart with more than 2 variables. 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Chart label alignment 0

Top