OaklandJim
Well-known Member
- Joined
- Nov 29, 2018
- Messages
- 833
- Office Version
- 365
- Platform
- Windows
I thought I'd gotten a better understanding of times in VBA and worksheets. Not quite. In VBA trying to test whether a cell is empty. Easy huh? IsEmpty(.Value) or if .value = "" right?
I'm missing SOMETHING. I cannot tell whether a cell that MIGHT be a time is empty. Empty cells keep evaluating to zero which is a time in Excel: Midnight. So my loop looking for specific times in an input range keeps detecting lots of phantom, 12:00 AM values. Of course I have one midnight value to detect so <> 0 does not work. Help me find the light of day here. Thanx In advance.
I'm missing SOMETHING. I cannot tell whether a cell that MIGHT be a time is empty. Empty cells keep evaluating to zero which is a time in Excel: Midnight. So my loop looking for specific times in an input range keeps detecting lots of phantom, 12:00 AM values. Of course I have one midnight value to detect so <> 0 does not work. Help me find the light of day here. Thanx In advance.