WINTER_007
New Member
- Joined
- Dec 25, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello, pretty new, not to excel but to tinkering at the vba level.
I am trying to do a simple search, select, copy, past on specific times and am hung up at an ultra-basic level.
I can do it if I wiggle around and make time become text and then filter/search by doing this: If Worksheets("Sheet1").Cells(I, 1).Value = "10:00 AM" or
But I have not figured out how to capture it if it is still in time format. It does not work if I put it in quotes like text and it does not work if I just put the value there with no quotes.
What is the right way/syntax to do that.?
Thank you for a pointer here.
Winter
I am trying to do a simple search, select, copy, past on specific times and am hung up at an ultra-basic level.
I can do it if I wiggle around and make time become text and then filter/search by doing this: If Worksheets("Sheet1").Cells(I, 1).Value = "10:00 AM" or
But I have not figured out how to capture it if it is still in time format. It does not work if I put it in quotes like text and it does not work if I just put the value there with no quotes.
What is the right way/syntax to do that.?
Thank you for a pointer here.
Winter