+ Reply to Thread
Results 1 to 6 of 6

Record Data Every Second Help

  1. #1
    Registered User
    Join Date
    10-23-2014
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    3

    Record Data Every Second Help

    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.

  2. #2
    Registered User
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: Record Data Every Second Help

    Not sure if this is what you're trying to achieve? Please try the below code.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-23-2014
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    3

    Re: Record Data Every Second Help

    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

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,193

    Re: Record Data Every Second Help

    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

  5. #5
    Registered User
    Join Date
    10-23-2014
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    3

    Re: Record Data Every Second Help

    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

  6. #6
    Registered User
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: Record Data Every Second Help

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Userform Edit Record and GoTo record Command Buttons
    By 139runner in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-30-2020, 12:54 AM
  2. Replies: 4
    Last Post: 12-17-2012, 10:14 AM
  3. Replies: 1
    Last Post: 11-16-2012, 09:25 AM
  4. Command Buttons for Viewing Record, Next Record and Previous Record
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2012, 06:30 AM
  5. Replies: 1
    Last Post: 01-17-2012, 10:47 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1