+ Reply to Thread
Results 1 to 10 of 10

Modify This Macro To Generate More Than 1048576 Number Sets

  1. 11-29-2015, 09:16 PM #1
    ssjagger
    ssjagger is offline
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Modify This Macro To Generate More Than 1048576 Number Sets

    I have this macro to generate numbers sets once my original number set is matched but the most I can generate is 1048576 sets.

    Can this macro be modified to generate more than 1048576 sets? Either on the same spreadsheet or additional spreadsheets?

    Please Login or Register  to view this content.
    Last edited by ssjagger; 12-03-2015 at 08:14 PM.
    Reply With QuoteRegister To Reply
  2. 11-29-2015, 09:24 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Modify This Macro

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )

    (also, you may not have noticed that 1048576 is the total number of rows in excel 2007 onwards?)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 11-30-2015, 09:59 PM #3
    ssjagger
    ssjagger is offline
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Modify This Macro

    Just to clarify my request. Currently when I try to generate more than 1048576 number sets (as FDibbins mentioned, 1048576 is the total number of rows in excel 2007 onwards) I get the error "Run-time error '104': Cannot empty the Clipboard.?

    I would like to be able to generate 2500000+ number sets.
    Reply With QuoteRegister To Reply
  4. 12-03-2015, 08:16 PM #4
    ssjagger
    ssjagger is offline
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    I've posted an attachment of the spreadsheet I'm working with.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-03-2015, 08:49 PM #5
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  6. 12-03-2015, 09:32 PM #6
    ssjagger
    ssjagger is offline
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    Thanks XLAdept,

    Sort of working, it overwrites the numbers in column n:p
    Last edited by ssjagger; 12-03-2015 at 09:55 PM.
    Reply With QuoteRegister To Reply
  7. 12-03-2015, 10:23 PM #7
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    You need to increment c by at least 4 vs 1
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  8. 12-03-2015, 11:52 PM #8
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    Sorry,

    I didn't know that N:P were populated - Ben's amendment should work!
    Reply With QuoteRegister To Reply
  9. 12-07-2015, 07:47 AM #9
    ssjagger
    ssjagger is offline
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    Excellent, that worked perfect. Thanks for your help~
    Reply With QuoteRegister To Reply
  10. 12-07-2015, 04:16 PM #10
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Modify This Macro To Generate More Than 1048576 Number Sets

    You're welcome and thanks for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Modify existing macro to include decimal and stop manual edit of macro
    By blueflwr19 in forum Excel General
    Replies: 2
    Last Post: 11-03-2014, 12:06 PM
  2. Macro Help - Modify macro to save as to specific location
    By scoochUM in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-30-2014, 04:10 PM
  3. Stop Macro, Check Cells & Modify if Necessary, Resume Macro
    By AccountantCost in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2009, 07:39 AM
  4. modify a macro; run macro again automatically for next cell if any error accurs
    By wali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2008, 09:21 AM
  5. modify macro
    By stevekirk in forum Excel General
    Replies: 4
    Last Post: 04-05-2007, 03:50 AM
  6. Can you modify one macro with another
    By creyavaich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2007, 06:45 PM
  7. [SOLVED] Modify a macro
    By Philippe Jacquet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 04:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1