+ Reply to Thread
Results 1 to 2 of 2

vba generated data reaches excel cell limit

  1. #1
    Registered User
    Join Date
    03-01-2019
    Location
    Mansfield
    MS-Off Ver
    2013
    Posts
    19

    vba generated data reaches excel cell limit

    Hi,
    i'm running a simulation of an insect and plant population dynamics. The simulation works perfctly with a small number of iterations (low values of UByear, UBday,nplants and Nsbb) however, it just occurred to me that entering the data with the intended number of iterations (UByear = 100, UBday = 120 and nplants = 300) will result in the data going over the 1048576 cell limit. Any suggestions as to how to enter all the data of interest? or put the data in a pivot table without entering into a worksheet?

    attaching workbook for reference!

    thanks in advance!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: vba generated data reaches excel cell limit

    Note that the limit is on the number of rows, not cells. So you might be able to redesign your layout to put more data on fewer rows. Although I greatly appreciate that you attached your file, I don't know how to to navigate or read it or what the code is supposed to do. Can you give a brief guided tour of what's going on and where you specify the iterations for those three variables?

    You can't put data in a pivot table that didn't come from some other source data. But since you are using VBA there might be other ways to display a summary of your data without having to display the raw data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. To set limit to value generated in a range
    By Vinosh in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-15-2017, 10:49 AM
  2. If initials are generated in a cell then a permanent date stamp is generated
    By pageandrewr1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-08-2016, 12:15 PM
  3. Collecting data from auto- generated excel file
    By nooredein in forum Excel General
    Replies: 6
    Last Post: 05-04-2014, 02:10 PM
  4. code needed to copy cell data to a newly generated tab
    By renrenren in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-14-2013, 09:26 AM
  5. [SOLVED] Copy and paste data into an excel generated cell location
    By BRIANHD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2013, 02:53 PM
  6. [SOLVED] Conditional formatting of a cell in a column if character count reaches a limit
    By Pavan Renjal in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 01-13-2013, 03:16 PM
  7. [SOLVED] how to color code a cell in excel if amount reaches a minus
    By Pat Mineard in forum Excel General
    Replies: 5
    Last Post: 06-16-2005, 11:05 AM

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