View Single Post
  #37   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default leading zeros using ActiveCell.Offset().value to insert row and value

On Fri, 15 Feb 2013 17:55:13 -0500, Ron Rosenfeld wrote:

On Fri, 15 Feb 2013 19:39:54 +0000, TimLeonard wrote:

If possible it would be best to only create the actual qty of loops for
each panel (NodeAddress) due to file size and run time of the macro as
well as the yet to be determined compare function


That can be done. Of course, doing it that way will ADD to the run time of this macro, but probably not by a lot; and it's stll taking well under 0.5 sec to excecute on my machine.


OK, I have now rewritten so as to limit the number of loops to be the number of loops per node.
Question: As written, all the Zones will sort together, at the end of the data table.
An alternate sorting scheme would be to have the Zones stay with the Nodes.
How would you like it?
And should the Z's be listed before or after the M's and D's?