Home Privacy Policy Feedback Link to us Site Map Forums

Excel: CVar Function (VBA only)


In Excel, the CVar function converts a value to a variant.

The syntax for the CVar function is:

CVar( expression )


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

VBA Code

The CVar function can only be used in VBA code. For example:

Dim LValue As Variant

LValue = CVar(8)

The variable called LValue would now contain the variant value of "8".