I have the following code which is intended to copy a column of cells and paste them up one position, triggered by a cell val. The problem is the code runs multiple times and performs the copy and paste multiple times. I have tried to insert a 1 second pause in the code to give time for the trigger cell to return to false, but it does not seem to work.
Please Login or Register to view this content.
Last edited by tmkkoservo; 10-10-2014 at 09:38 AM.
You've got this set to run every time it calculates. When you update the cells using this code it will cause a calculation which means the code will be triggered again. Maybe using a different trigger would be better.
The trigger cell is a link to an external data source. I have tried worksheet change a long time ago for this but I remember it seemed to only work if I typed a value into the trigger cell and pressed enter.
Yeah change the trigger & you could try puttingin your code where you want it to exit at. Or create a Test to check if the task needs to be done in the first place. Something like thisPlease Login or Register to view this content.Please Login or Register to view this content.
Last edited by dlow; 10-10-2014 at 09:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks