GeneBat
asked on
Variant Math in VBA
How do I add 2 variant variables in VBA?
Dim bTotalsfsAOS as Variant
If rs.Fields(0).Value = "N" Then
bTotalsfsAOS = Val(bTotalsfsAOS) + FormatNumber(rs.Fields(5))
End If
When I use this code is returns the variants concatenated and not added.
Dim bTotalsfsAOS as Variant
If rs.Fields(0).Value = "N" Then
bTotalsfsAOS = Val(bTotalsfsAOS) + FormatNumber(rs.Fields(5))
End If
When I use this code is returns the variants concatenated and not added.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.