'Methods' category


Subcategories

  • Evaluate method (1)
  • Range.Find method (1)
  • TextToColumns method (1)

  • How to use the EVALUATE method
    The Evaluate method converts an Excel name to an object or value. The picture above demonstrates a macro that uses […]
    How to use the RANGE.FIND method
    The┬áRange.Find┬ámethod returns a range object for the first cell that matches the lookup value. Macro used in workbook above The […]
    How to use the TEXTTOCOLUMNS method
    The TextToColumns method puts a cell that contains a string into substrings and distributes them horizontally using a delimiting character […]

    Excel categories