Results 1 to 6 of 6

Reference cell as time value

Threaded View

rhudgins Reference cell as time value 03-29-2011, 01:25 PM
nimrod Re: Reference cell as time... 03-29-2011, 02:27 PM
rhudgins Re: Reference cell as time... 03-29-2011, 04:22 PM
nimrod Re: Reference cell as time... 03-29-2011, 04:36 PM
rhudgins Re: Reference cell as time... 03-30-2011, 12:36 PM
rhudgins Re: Reference cell as time... 03-30-2011, 12:43 PM
  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Reference cell as time value

    On my worksheet Y58 has the value 13:21:00. How can I change the code below to reference the cell Y55 as the time value?

    Sub CopyLiveTradeData()
        Application.OnTime TimeValue("13:21:00"), "StartOnTime"
    
    End Sub
    Last edited by rhudgins; 03-30-2011 at 12:44 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