+ Reply to Thread
Results 1 to 3 of 3

Finding Date and Position Cursor

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007 / Excel 2010
    Posts
    106

    Finding Date and Position Cursor

    I'm building a macro and need assistance with a portion of it. I've also attached a sample file that I'm working with.

    The macro should do the following:

    1- Using the Date-Time data in cell “T3” find the cell in column “A” that has the same Date and time.
    2- Position the cursor in column I of the same Row.
    3- End

    In the example giving the Date-Time in “T3” is: 07/03/2008 17:15:00

    The Cell in column “A” that has this same Date-Time is: “A97”

    The cursor should then be positioned in Cell “I97”

    Please let me know if you have any questions. Think this should be pretty easy for you guys.
    Attached Files Attached Files
    Last edited by ExcelQuestFL; 08-07-2009 at 11:07 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Finding Date and Position Cursor

    Not sure why you just want to go to the cell but this should work:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007 / Excel 2010
    Posts
    106

    Re: Finding Date and Position Cursor

    Thanks! I'm building a macro with some additional logic so this is the beginning piece I had difficulty with. Once I'm back to that cell I think I should be able to finish it off. As always, I appreciate the assistance.

+ Reply to Thread

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