View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default is object chart?

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

-----Original Message-----
Hi,
How recognize (in VBA) is activeobject chart?

Best regards
Mark

.