Results 1 to 12 of 12

Find time value in VBA

Threaded View

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Find time value in VBA

    For the life of me can't figure this one out.

    In Column A one of the values is 2:33:30 PM

    In Range("D1") 2:33:30 PM

    How come the code below will not find the value in column A?

    I changed the value in D1 to the number 2 and placed a 2 in Column A and it finds the 2, just having no luck with a time.

    Set Found = Columns("A").Find(what:=Range("D1").Value, LookIn:=xlValues, LookAt:=xlWhole)
    Found.Address
    Any thoughts?
    Last edited by jeffreybrown; 05-18-2011 at 01:51 PM.
    HTH
    Regards, Jeff

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