+ Reply to Thread
Results 1 to 2 of 2

sheet.cells(index1,index2) overflow error

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    us
    MS-Off Ver
    2013
    Posts
    1

    sheet.cells(index1,index2) overflow error

    I have a macro that generates a lot of output
    for each case(c) there are multiple iterations(i) that need to be transferred to an output worksheet

    the reference for the output area is of the form
    Please Login or Register  to view this content.
    iterations is a user-defined constant, and case_number is the the number of cases run thus far.
    neither iterations nor case_number exceed the limit for an integer, but when their product exceeds 32701, I get an overflow error

    I'll try setting caseNumber and iterations to long, but if that works, what's up with that?
    Last edited by Leith Ross; 01-12-2015 at 10:13 PM. Reason: Added Code tags

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: sheet.cells(index1,index2) overflow error

    Did you try changing the data type to Long?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Overflow error on worksheet_selectionchange when counting selected cells
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2021, 01:05 PM
  2. Run Time Error '6' Overflow - Macro That Find Text and Copy Range & Replace on Other Sheet
    By asgharhussaini in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:34 AM
  3. [SOLVED] inserting cells when conditions not met, overflow error
    By vcorby in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2012, 01:10 PM
  4. Overflow error copying cells?
    By AussieM8 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2010, 11:10 AM
  5. [SOLVED] Overflow error - same code, different sheet
    By rwnelson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2006, 12:35 PM

Tags for this Thread

Bookmarks

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