I have a macro that is supposed to write a subtotal to a
new line. However, it sometimes writes a line with
previous data.

Our latest attempt to correct this issue concerns the
clipboard. Is it possible the clipboard is not getting
cleared and writing the same information again?

Any suggestions on how to clear the clipboard would be
appreciated or how to verify that this is the problem
would also help.

I tried to record a macro pushing the clear all on the
clipboard toolbar but that did not work. Thanks.