Hello. I need to get the index of the selected series. I've wrote some code
that should work but doesn't, and after a while I need some fresh input on
the topic. The code would be like this:
if typename(selection) <> "Series" then exit sub
For i=1 to in activechart.seriescollection.count
if selection is activechart.seriescollection(i) then indexnum=i
'BINGO
next
The problem is the failure of the object comparizon. Am I doing something
wrong? Is there anyway of doing this in an errorprof manner? (Comparing
formulas isn't errorprof).
Thanks for reading!!
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
