I am working on a transaction/traffic conversion rate. I've written VBA funtions which gather the traffic count and transaction count. Each function works fine individually, but when I try to divide one by the other, I recieve an Run-time error'13': type mismatch .
Here are the main pieces of code:
Dim TrafficCount As Variant
TrafficCount = TrafficOut(BegDate, EndDate)
Range(Cell).Value = TransactionCount(BegDate, EndDate) / TrafficCount
Function TrafficOut(BegDate1, EndDate1) As Variant
Function TransactionCount(BegDate1, EndDate1) As Variant