LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default reseting hidden shape counter

Greetings,

I have a program that (as part of an animation involving vectors in a
plane) creates then deletes a large number of arrows on a chart. It
works fine, but when I click on one of the arrows I see that its name
is something like "Line 5265" even though there are only 2 vectors
actually in existence (so that myChart.Shapes.Count correctly gives
2). It seems weird that the Count property is reset upon delete but
that there is some behind-the-scenes counter which isn't reset. This
isn't pressing since I don't use the name in my code (and know how to
change it if I needed to - which, by the way, doesn't reset this
hidden counter either) but have a concern that maybe the code will
crash after 65536 lines have been created (and mostly deleted) since
for all I know there is a 16-bit int counter in the code for Excel
which will trigger a bug upon overflow. Is there any way to reset the
numbering so that the default numbering of a new shape only depends on
the current count? Also- is there anything behind my fear that
eventually such large numbers in the shape name might lead to a
harmful overflow? Just curious.

-scattered
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reseting to 0. GEM Excel Discussion (Misc queries) 3 April 3rd 09 12:22 AM
Did I stump everyone? Counter that ignores hidden rows TechMGR Excel Discussion (Misc queries) 2 April 5th 05 08:45 PM
Creating a counter that does not include hidden rows TechMGR Excel Discussion (Misc queries) 1 April 4th 05 10:11 PM
Reseting Shape counter Don Guillett[_4_] Excel Programming 0 August 25th 04 03:02 PM
Reseting Shape counter Tom Ogilvy Excel Programming 0 August 25th 04 02:51 PM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"