leading zeros using ActiveCell.Offset().value to insert row and value
On Sun, 10 Feb 2013 00:20:45 +0000, TimLeonard wrote:
Response 1:
By the way, I would assume, from what you've posted that the range of
acceptable values for Merged Address is:
Part 1 Part 2 Part 3
L01 - L10 D or M 001 - 159
e.g. L01D001 to L10M159
Actually each loop has 159 "D";s and 159 "M"'s
e.g. Loop 1 = L01D001 to L01D159 & L01M001 to L01M159
up to Loop 10 = L10D001 to L10D159 & L10M001 to L10M159
I did mean to imply that the range would include "D" and "M" for each loop. Sorry if I was not clear
|