ByRef argument type mismatch

[roscoe]

Take 2

I have a function that converts Zulu time (or GMT if preferred) to local time (accounting for Daylight savings as appropriate) that has worked for years. Never had an issue. Today, I'm adding new code that requires such a conversion but the new code fails per the "ByRef argument type mismatch" error when I call the function. The function in question requires a DATE type value and I've verified that is what I'm sending it. I'm lost at this point.

Any hints as to what to look for would be greatly appreciated!

Thanks!

(Note: I can't use the built-in help function because Microsoft in their infinite wisdom now keeps the help files online...but my system is off the grid for proprietary reasons and can no longer access help files)

 

[Joe4]

I think VBA had developed cobwebs

In all my years, I have never heard of anything like that. It usually doesn't just go flaky for no reason.
You could have a corrupted file.