+ Reply to Thread
Results 1 to 2 of 2

Run-time error 6 : overflow

  1. #1
    Registered User
    Join Date

    Run-time error 6 : overflow


    following on from a previous thread (http://www.excelforum.com/showthread.php?t=596847) I have encountered a runtime error when using more than 13 binary A/B variables and one A/B/C variable. more specifically the error occurs when the total number of combinations exceeds 32767 rows (in this example the number of combinations = (2^13)*3 = 24576). The arrays were initially set up as variant although I have also tried it with String arrays (since all the combinations are of names only).

    Is there anyway of removing this error? I'm using Microsoft excel 2003 and VBA 6.3

    I'm also copying the combinations to 14 other worksheets and can not save the file afterwards as it is too big, is there anyway of reducing the file size too?


  2. #2
    Forum Contributor Tarball's Avatar
    Join Date
    Atlanta, GA
    32767 is the maximum size of a variable of type integer. Change the variable to type Long or type Double. This allocates more memory which translates in the ability to store a much larger number.

    I have never heard of a size limitation on saving worksheets. Look that one up on microsoft.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1