Thread: leading zeros using ActiveCell.Offset().value to insert row and value
View Single Post
  #36   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 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.
Reply With QuoteReply With Quote