'Functions' category


  • ARRAY function (1)
  • Fix Function (1)
  • INT function (1)
  • JOIN function (1)
  • Lbound Ubound function (1)
  • SGN function (1)
  • SPLIT function (1)

  • How to use the ARRAY function [VBA]
    The ARRAY function creates a Variant variable containing array values. Table of Contents Array Function VBA Syntax Array Function Arguments […]
    How to use the LBOUND and UBOUND functions
    The Lbound and Ubound functions calculate the size of of an array. The Lbound returns the lower limit of an array and […]
    How to use the JOIN function [VBA]
    The JOIN function concatenates a set of substrings in an array, the image shows a user-defined function entered in cell […]
    How to use the SGN function [VBA]
    The SGN function returns an integer that shows the sign of the number. Argument SGN returns Number greater than 0 (zero). […]
    How to use the FIX function [VBA]
    The FIX function removes the decimals from the argument. Excel Function VBA Syntax Fix(number) Arguments number Required. Is a Double or […]
    How to use the INT function [VBA]
    The INT function removes the decimals if the numeric value is above 0 (zero) and returns a negative integer less than […]
    How to use the SPLIT function [VBA]
    The picture above shows a user-defined function (UDF) that splits the string in cell C3 using a delimiting character ",". […]

    Excel categories