I am trying to pass a long variable into a ByVal Variant and I am getting a type mismatch error? Any ideas? If I change the type to a Long it works?! Shouldn't the ByVal Variant work also?