LinkBack URL
About LinkBacks
I am running a Macro every minute, where I copy the range Cells C13:D13 on Main sheet, and paste it into next available row in Log sheet column A.
The Macro does run but it does copy and paste the values twice. I cant seem to understand why.
I am running a Macro every minute, where I copy the range Cells C13:D13 on Main sheet, and paste it into next available row in Log sheet column A.
The Macro does run but it does copy and paste the values twice. I cant seem to understand why.
You started another "With" blcok without closing the first one.
I have adjusted in your file.
your code runs ok here-are you sure you hadn't set it running twice?
Josie
if at first you don't succeed try doing it the way your wife told you to
Ahh yes! Because it runs as soon as the workbook opens. But can also start manually. Thanks guys!
Thank you very much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks