Results 1 to 3 of 3

Time delay to change cell reference

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Question Time delay to change cell reference

    Hi Guys,

    I need a code which will take a lump of data, B2:AW366 and cycle through the data in a single cell (A1)

    So to clarify Cell A1 should cycle through:

    B2
    C2
    D2
    E2
    ...
    ...
    ...
    AU2
    AV2
    AW2
    B3
    C3
    D3
    E3
    .....
    .....
    Continue until cell AW366 reached.


    If possible i would like the speed of the cycle to be variable, So i can select a 0.5 second delay before Cell A1 changes to the next reference.

    Many Many Thanks
    Last edited by freud1; 06-16-2009 at 12:04 PM.

Thread Information

Users Browsing this Thread

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

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