Cross posted (with some answers) here...

Macro to create Sub-account numbers