Could someone tell me why I'm getting a type mismatch error on this code? I've been messing with it for hours and I can't figure out why.
Sub Macro1()
Dim LookupValue As Double
Dim VLookupResult As Double
Dim myTableArray As Range
LookupValue = TimeValue("5:00:00 AM")...