GetFormulaUnitDataObj(FormulaName)

This method retrieves all settings from existing Units on a certain Formula. These Units are the destination of saved data in a Formula, or values. This method contains the FormulaName parameter, which informs Formula's name.

Use this method to get a collection of Units of a Formula. This method returns True if this operation is successful or False otherwise. The next code contains a usage example of this method.

Sub Button1_Click()
  Dim val
  ' When clicking the button, displays a
  ' message box with the number of Units and the name
  ' of the First Unit
  Set obj = Application.GetFormulaUnitDataObj("Formula1")
  MsgBox CStr(obj.Count)
  MsgBox CStr(obj.Name(1))
End Sub