Compile Error: byref argument type mismatch
I will occasionally encounter this error when I do something like:
dim foo, doo, coo as string
I've found 1 of 2 ways to solve this error:
Change the data type to
variant
as indim foo, doo, coo as variant
Simply putting each on their own line:
dim foo as string
dim doo as string
dim coo as string
I've seen this twice, specifically when using these variables as parameters in functions. Is this a known bug? Is there something intrinsic to defining multiple variables on the same line that I'm missing?