Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Retrieving Values Stored as a Workbook Name Using the Evaluate Method
Sub TestWorkbookNameValue() 
    Dim vValue As Variant 
    vValue = Application.Names("SalesTaxRate").RefersTo 
    Debug.Print "Value retrieved using RefersTo: " & vValue 
End Sub