Bob,

That works! I think you were right, when the formats were pasted the
sheet recalculates because there was a change. Thus the macro starts
over and so on. Your code worked great for me, thanks for the quick
reply.