Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    VBA Functions Excel Functions

    Uploaded by

    Stefan Cioara
    excel2

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    VBA Functions Excel Functions

    Uploaded by

    Stefan Cioara
    17 views3 pages
    excel2

    Original Title

    Binary Functions

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    excel2

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    17 views3 pages

    VBA Functions Excel Functions

    Uploaded by

    Stefan Cioara
    excel2

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    Binary and Text Concatenation Functions

    Value
    DectoBin
    BintoDec
    Value
    DectoBin
    BintoDec

    VBA Functions Excel Functions


    511
    511
    #VALUE! 111111111
    #VALUE!
    511
    512
    #VALUE!
    #VALUE!

    512
    Err:502
    Err:502

    Convert columns of values to binary strings, decimal values, or text strings


    1
    2
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    1
    BinRangeToString
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    Count
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    BintoDec
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    Count
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    TextString
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    Count
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!

    Disclaimer
    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.
    A copy of the GNU General Public License may be obtained from:
    The Free Software Foundation, Inc.
    59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

    [email protected]
    www.interactiveds.com.au

    Copyright 2014 Interactive Design Services Pty Ltd. all rights reserved
    Code for binary functions is taken from code at: http://visualbasic.happycodings.com/applicati

    Revision History
    Current Version
    Rev

    Date
    1

    1.00
    By
    30-Sep-14 DAJ

    30-Sep-14

    Description
    First release

    codings.com/applications-vba/code4.html

    You might also like