View Single Post
  #32   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 Thu, 14 Feb 2013 20:34:23 +0000, TimLeonard wrote:


The format NxxxLyyyDzzz is fine with me

Makes things simpler.

However I noticed in you latest code that if the NodeAddress is 1 that
it keeps the first ten loop as LyyDzzz and then when it hits 2 it
changes to NxxxLyyDzzz. Is it possible that if it has more than one
node address, that all would use the same format NxxxLyyDzzz. That way
it looks consistent


Yes it is. I didn't know which way you wanted it.



Yes if more then one NodeAddress then NxxxZxxx would work fine.


OK


Question.
Is it the intent of the code to add all ten loop when the NodeAddress
increases. For example I noticed that if I added a NodeAddress of 2 and
a LoopSelection of 1 at the bottom of the PanelData sheet, it adds all
ten loop for that NodeAddress of two. In the field the panels could
have any amount of loops up to ten. I am just questioning because the
summary sheet would need to follow the same layout


The code does that, since, as written, it doesn't differentiate the number of loops from the number of loops per node. It doesn't have to.

Should we?

Or, if there are multiple nodes, should we only populate the "full list" up to the maximum number of loops per node?

An associated question would be: Will all ten loops in node 1 be used before going on to node 2. Or could we have, for example, Node 1 with three loops, Node 2 with five loops, and Node 3 with 1 loop?