Hi I have this code I am using to copy and paste.
The problem I have is - I can get the copy and paste to work and stop if I insert an ActiveX control button assigned to the StartTimer1 and StopTimer1 but I wish the Macro to run automatically based on a value in a cell.
For example - Sheet1 cell A1 has the number 1 inserted into the cell - then the StartTimer1 starts copy and pasting the data. Once the the number 1 is cleared from the cell the StopTimer1 stops the copy and pasting if the number 1 is re-entered into A1 the copy and paste starts again - and so on and so on.
Thank you for your time
Regards
Gally
Bookmarks