Hi All
I have been looking on line for a macro that record data in excel for every second, I managed to find one but the macro on captures the data on one cell though so I want to tweak it so that it captures a whole column
But it don't seems to be working, the macro below still only record the data for the first cell, any suggestions on what I've done wrong?
Thanks in advance!
Please Login or Register to view this content.
Last edited by fuonli; 10-26-2014 at 12:05 PM.
Not sure if this is what you're trying to achieve? Please try the below code.
Please Login or Register to view this content.
Thanks for your help Jayesh25
It is what I am trying to achieve but problem with copy and paste is that I cannot continue to work/navigate the spreadsheet whilst the macro is running, hence the reason why I used the .value instead but I cant get it to work
Any other suggestions?
Thanks
Fu On
Hi, fuonli,
please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure in the opening post.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Apologies HaHoBe
It was my first post, still learning. I have edited the original post to comply with the rules
So do any have any suggestions on how I can solve this code?
Thanks
Fu On
Hi fuonli,
This should fullfill your requirements i hope. Please change the (counter,10) number to whatever column you'd like to record your back up data to.. Currently it's set to column 10 which will be column J
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks