I think I am close on this, but it is not quite working as intended. The first version of this VBA was originally created to loop through a list on the "CertData" sheet and print the output as a defined range on sheet "Certificate". This worked perfectly, but I would rather have it loop...