This is probably an easy answer... I have a template sheet that performs a calculation dependent upon a unit number. I want to loop through all unit numbers and create copy of the template sheet for each unit. I believe I can make everything work except for naming the newly created sheet. I don't know what generic name Excel will give it, so I need to name the active sheet. Activesheets.Name didn't work. The name will be the unit name listed in cell B2.
Thanks for any help.