+ Reply to Thread
Results 1 to 4 of 4

VBA code will not iterate cell values.

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    15

    VBA code will not iterate cell values.

    Hello all,

    I am working on a excel file that that I would like the sums two dates sum and converted into seconds and then transfer the calculations to a .csv file. I received help on this forum a little while ago, however I am now having a bit of an issue with VBA code for my file.

    In the attached file the line of code that was given to me:
    Please Login or Register  to view this content.
    That should return the amount of seconds between the sum of time times Brain!B$2 (Today()) and 'Request Guest'!D3(Date entered by me on the request guest worksheet) *86400.

    Everything works fine expect in the line of code from the attached worked sheet:
    Please Login or Register  to view this content.
    'Request Guest'!D2 in the formula MAX(0,'Request Guest'!D2-Brain!B$2)*86400) dose not update to the next cell value !D3, !D4, ect..
    I have tried to rewrite the formula but either the new formula produces an error or dose not return the correct results.

    I am not sure how to get this value to update correctly?

    Any help is much appreciated!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,038

    Re: VBA code will not iterate cell values.

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-20-2014
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA code will not iterate cell values.

    Quote Originally Posted by TMS View Post
    Please Login or Register  to view this content.

    Regards, TMS
    Awesome Thank!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,038

    Re: VBA code will not iterate cell values.

    You're welcome.


    Looked kinda familiar anyway

+ 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. Iterate through values meeting specific conditions
    By pico32 in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 05:14 AM
  2. Iterate and concatenate matching values
    By raystafarian in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2012, 07:59 AM
  3. How to iterate angle values between 0 to 2pi
    By rosh72851 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2008, 07:29 PM
  4. Iterate until cell values match
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-03-2008, 01:01 AM
  5. Replies: 3
    Last Post: 05-31-2007, 10:47 AM

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