-
How do I search a spread sheet for a time
I have a spreadsheet with a times in a column in the "hh:mm" format.
I want to find the 21:45 time period in vba and insert it into a function as a variable.
So far I have
Dim NYClose As Date (is that correct to Dim a time as Date?)
NYClose= "21:45"
Am I going about this correctly?
What do I need to do to the "21:45" to make the NYClose variable the "21:45" time period I am looking for?
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules