• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VB Code is not running when amount is greater than 32,767

Mukund Vyas

Member
hello all

I have a invoice.xlsm file, there is sale invoice format, and i have a code which extracts all details to new sheet.
but when there is amount greater than 32,767 in total amount cell.. code is not running.. its showing debug or end..
i am attaching that file here..
Please help me..
 

Attachments

  • INVOICE.XLSM
    154 KB · Views: 5
To add to what Deepak said, if you call up the VB help, you'll find this info
Integer variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767.
Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.
 
Back
Top