Forum Discussion
Macro stops working
I have a macro command that should perform an action every minute between certain hours, the command initially works as it should but after 8 times it stops working Although Excel stays open all the ...
I assume that the Workbook_Open line doesn't belong there, or that you forgot to post the code of that procedure.
Apart from that, your CopyValue macro will write to the sheet that is active when the code runs, even if you have activated another sheet or even another workbook in the meantime. So the data could become scattered over multiple sheets. It'd be better to specify the workbook and worksheet explicitly.